Skip to content

Supabase

Supabase provides the PostgreSQL database. You'll set up a project and construct a connection URL that the MCP server uses at runtime.

  1. Go to supabase.com/dashboard and create an account
  2. Click New Project, choose an organization, set a project name, database password, and region
  3. Note the Project Reference ID from the project URL: https://supabase.com/dashboard/project/<project-ref>

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

The MCP server connects via asyncpg using a DATABASE_URL environment variable. Build it from your Supabase dashboard:

  1. Go to ConnectConnection StringTransaction pooler (port 6543)
  2. 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)

After completing this step you should have the next values:

KeyValueWhere to get itPurpose
SUPABASE_ACCESS_TOKENSupabase personal access tokensupabase.com/dashboard/account/tokensGithub secret
SUPABASE_PROJECT_IDProject reference IDFrom the project URL: supabase.com/dashboard/project/<project-ref>Github secret
SUPABASE_DB_PASSWORDDatabase passwordSet during project creationGithub secret
DATABASE_URLConnection URLSee hereServer secret