Self-Hosted Supabase MCP Server

Lists all accessible tables in the connected database, grouped by schema.

Lists all installed PostgreSQL extensions in the database.

Lists applied database migrations recorded in supabase_migrations.schema_migrations table.

Applies a SQL migration script and records it in the supabase_migrations.schema_migrations table within a transaction.

Executes an arbitrary SQL query against the database, using direct database connection when available or RPC function as fallback.

Retrieves information about active database connections from pg_stat_activity.

Retrieves statistics about database activity and the background writer from pg_stat_database and pg_stat_bgwriter.

Returns the configured Supabase project URL for this server.

Returns the configured Supabase anon key for this server.

Returns the configured Supabase service role key for this server, if available.

Generates TypeScript types from the database schema using the Supabase CLI (supabase gen types) and downloads the file to the specified absolute path. The tool returns the current platform (win32, darwin, linux) to help with path formatting. Requires DATABASE_URL configuration and Supabase CLI installed.

Attempts to restart the pg_net worker. Requires the pg_net extension to be installed and available.

Checks if the Supabase JWT secret is configured for this server and returns a preview.

Lists users from the auth.users table.

Retrieves details for a specific user from auth.users by their ID.

Deletes a user from auth.users by their ID. Requires service_role key and direct DB connection.

Creates a new user directly in auth.users. WARNING: Requires plain password, insecure. Use with extreme caution.

Updates fields for a user in auth.users. WARNING: Password handling is insecure. Requires service_role key and direct DB connection.

Lists all storage buckets in the project.

Lists objects within a specific storage bucket, optionally filtering by prefix.

Lists PostgreSQL publications, often used by Supabase Realtime.