How do I install the selfhosted supabase mcp basic auth mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `SUPABASE_URL`, `SUPABASE_ANON_KEY`, `SUPABASE_SERVICE_ROLE_KEY`, `DATABASE_URL`, `SUPABASE_AUTH_JWT_SECRET` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Selfhosted Supabase MCP Basic Auth MCP Server

This project provides a [Model Context Protocol (MCP)](https://github.com/modelcontextprotocol/specification) server designed specifically for

Remote serverstreamable-httpTypeScript

What is the Selfhosted Supabase MCP Basic Auth MCP Server?

This project provides a Model Context Protocol (MCP) server designed specifically for interacting with

What you get

Schema & Migrations —
list_tables: Lists tables in the database schemas
list_extensions: Lists installed PostgreSQL extensions
list_migrations: Lists applied Supabase migrations
apply_migration: Applies a SQL migration script
Database Operations & Stats —

Configuration and credentials

Node.js (Version 18.x or later recommended) * npm (usually included with Node.js) * Access to your self-hosted Supabase instance (URL, keys, potentially direct DB connection string).

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
list_tables	Lists tables in the database schemas.
list_extensions	Lists installed PostgreSQL extensions.
list_migrations	Lists applied Supabase migrations.
apply_migration	Applies a SQL migration script.
execute_sql	Executes an arbitrary SQL query (via RPC or direct connection).
get_database_connections	Shows active database connections (pg_stat_activity).
get_database_stats	Retrieves database statistics (pg_stat_*).
get_project_url	Returns the configured Supabase URL.
get_anon_key	Returns the configured Supabase anon key.
get_service_key	Returns the configured Supabase service role key (if provided).
verify_jwt_secret	Checks if the JWT secret is configured and returns a preview.
generate_typescript_types	Generates TypeScript types from the database schema.
rebuild_hooks	Attempts to restart the pg_net worker (if used).
list_auth_users	Lists users from auth.users.

Configuration

Node.js (Version 18.x or later recommended) * npm (usually included with Node.js) * Access to your self-hosted Supabase instance (URL, keys, potentially direct DB connection string).

Variable	Description	Required
SUPABASE_URL	Endpoint or connection string the server talks to.	Yes
SUPABASE_ANON_KEY	Credential the server authenticates with.	Yes
SUPABASE_SERVICE_ROLE_KEY	Credential the server authenticates with.	Yes
DATABASE_URL	Endpoint or connection string the server talks to.	Yes
SUPABASE_AUTH_JWT_SECRET	Credential the server authenticates with.	Yes

Example prompts to try

“Use Selfhosted Supabase MCP Basic Auth to list tables.”
“Use Selfhosted Supabase MCP Basic Auth to list extensions.”
“Use Selfhosted Supabase MCP Basic Auth to list migrations.”

Frequently asked questions

This project provides a [Model Context Protocol (MCP)](https://github.com/modelcontextprotocol/specification) server designed specifically for interacting with Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.