How to configure Supabase as a database for a Spring Boot application?

Question

I’m working on a Spring Boot application and I’d like to use Supabase database as my database.

I’ve successfully set up Supabase and created a project, but I’m having trouble configuring it in my Spring Boot application, and also trouble with an endpoint of mine.

My current setup:

Spring Boot version: 3.2.5

What I’ve tried:

Added the necessary PostgreSQL dependencies to my pom.xml:

<dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifactId></dependency>
Configured my application.properties with the details provided by Supabase:

spring.datasource.url=jdbc:postgresql://<supabase-host>:5432/<database-name>
spring.datasource.username=<supabase-user> 
spring.datasource.password=<supabase-password>
spring.datasource.driver-class-name=org.postgresql.Driver

I’m not sure if this configuration is sufficient or if there are additional settings required to fully integrate Supabase with Spring Boot.

Abdul Wasey Khan · Accepted Answer · 2025-06-30 21:20:36Z

1

spring.datasource.driver-class-name=org.postgresql.Driver
spring.datasource.url={YOUR JDBC URL}&password={YOUR SUPABASE DB PASSWORD}
spring.datasource.username={Your DB User Name From Supabase}
spring.datasource.password={Your DB Password From Supabase}
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=none

You need to get the JDBC connection String from connect --> Type --> JDBC and scroll to Session Pooler to get the JDBC URL and credentials.

For step by step process please see my blog below:https://medium.com/@khan.abdulwasey99/step-by-step-process-on-how-to-connect-a-spring-boot-application-to-supabase-f1791e1d2402

Re-posting I was not aware of Stackoverflow guidelines for external blogs.

answered Jun 30 at 21:20

Abdul Wasey Khan

262 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

amir BEN AHMED · Accepted Answer · 2025-06-30 07:55:21Z

1

You can do something like that :

# Supabase configuration
supabase.url=${SUPABASE_URL}
supabase.anon=${SUPABASE_ANON_KEY}
supabase.jwt_secret=${SUPABASE_JWT_SIGNER}

# Spring application configuration
spring.application.name=Demo
spring.main.banner-mode=off

# Spring datasource configuration
spring.datasource.url=${SUPABASE_DATABASE_URL}
spring.datasource.username=${SUPABASE_DATABASE_USER}
spring.datasource.password=${SUPABASE_DATABASE_PASSWORD}
spring.datasource.driverClassName=org.postgresql.Driver

answered Jun 30 at 7:55

amir BEN AHMED

212 bronze badges

Comments

Devanshu Verma · Accepted Answer · 2024-12-19 11:20:26Z

0

You can try using the connection string of type JDBC. Use either direct connection string or session pooler string. Remove the username and password fields from your code. Just this is enough-> spring: datasource: url: string as taken from supabase

make sure to include your db password in the connection string

answered Dec 19, 2024 at 11:20

Devanshu Verma

1

Collectives™ on Stack Overflow

How to configure Supabase as a database for a Spring Boot application?

My current setup:

What I’ve tried:

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

My current setup:

What I’ve tried:

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related