Schema | supabase-schema-mcp

supabase-schema-mcp

Describes the environment variables required to run the server.

Name	Required	Description
`SUPABASE_DB_HOST`	Yes	The Supabase database host (e.g., db.<project_ref>.supabase.co)
`SUPABASE_DB_NAME`	No	The database name (optional, default 'postgres')
`SUPABASE_DB_PORT`	No	The database port (optional, default 5432)
`SUPABASE_DB_USER`	Yes	The database user (usually 'postgres')
`SUPABASE_DB_PASSWORD`	Yes	The database password

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
schema_list_tablesA	List tables in the schema (default: public). Use schema_name='all' for all.
schema_list_columnsA	List columns for tables in the schema. Optionally restrict to one table.
schema_list_viewsA	List views in the given schema. Use schema_name='all' for all user schemas.
schema_list_enumsA	List custom enum types. Use schema_name='all' for all user schemas.
rls_list_policiesA	List RLS policies (table, policy, command). schema_name='all' for all schemas.
rls_list_coverageA	Report tables with RLS enabled and policy counts. schema_name='all' for all.
rls_get_policyA	Return the definition (USING and WITH CHECK code) of an RLS policy by name.
functions_listA	List Postgres functions (signature, return type). schema_name='all' for all.
functions_list_rpc_candidatesC	List Supabase RPC-callable function candidates. schema_name='all' for all.
functions_get_definitionB	Return the full source code (CREATE FUNCTION) of an RPC/function by name.
relationships_list_foreign_keysA	List foreign keys (from/to table and columns). schema_name='all' for all.
relationships_list_indexesA	List indexes (table, index, columns). schema_name='all' for all schemas.
triggers_listA	List triggers (table, trigger, timing, event). schema_name='all' for all.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/HarryB05/supabase-schema-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server