Supabase
Supabase provides the PostgreSQL database. You'll set up a project and construct a connection URL that the MCP server uses at runtime.
Create a project
Section titled “Create a project”- Go to supabase.com/dashboard and create an account
- Click New Project, choose an organization, set a project name, database password, and region
- Note the Project Reference ID from the project URL:
https://supabase.com/dashboard/project/<project-ref>
Enforce SSL
Section titled “Enforce SSL”For extra security it's recommended to enable "Enforce SSL on incoming connections" setting.
It can be found using next link: https://supabase.com/dashboard/project/<project-ref>/database/settings#ssl-configuration
Construct the connection URL
Section titled “Construct the connection URL”The MCP server connects via asyncpg using a DATABASE_URL environment variable. Build it from your Supabase dashboard:
- Go to Connect → Connection String → Transaction pooler (port
6543) - The URL follows this format:
postgresql://postgres.<project-ref>:<password>@<pooler-host>:6543/postgres?sslmode=verify-full<pooler-host>- copy the host from the transaction pooler connection string<password>- your database password, URL-encoded (special characters like@,!,#,%must be escaped, e.g.p@ss!→p%40ss%21)
Outputs
Section titled “Outputs”After completing this step you should have the next values:
| Key | Value | Where to get it | Purpose |
|---|---|---|---|
SUPABASE_ACCESS_TOKEN | Supabase personal access token | supabase.com/dashboard/account/tokens | Github secret |
SUPABASE_PROJECT_ID | Project reference ID | From the project URL: supabase.com/dashboard/project/<project-ref> | Github secret |
SUPABASE_DB_PASSWORD | Database password | Set during project creation | Github secret |
DATABASE_URL | Connection URL | See here | Server secret |