Supabase MCP Server (Used By Deploya.dev)

get_db_schemas

Lists all database schemas with their sizes and table counts

get_tables

Lists all tables in a schema with their sizes, row counts, and metadata

get_table_schema

Gets detailed table structure including columns, keys, and relationships

execute_sql_query

Executes raw SQL queries with comprehensive support for all PostgreSQL operations:

send_management_api_request

to send arbitrary requests to Supabase Management API, with auto-injection of project ref and safety mode control

get_management_api_spec

to get the enriched API specification with safety information

get_management_api_safety_rules

to get all safety rules including blocked and unsafe operations with human-readable explanations

live_dangerously

to switch between safe and unsafe modes

get_auth_admin_methods_spec

to retrieve documentation for all available Auth Admin methods

call_auth_admin_method

to directly invoke Auth Admin methods with proper parameter handling

get_user_by_id

Retrieve a user by their ID

create_user

Create a new user

delete_user

Delete a user by their ID

invite_user_by_email

Send an invite link to a user's email

generate_link

Generate an email link for various authentication purposes

update_user_by_id

Update user attributes by ID

delete_factor

Delete a factor on a user (currently not implemented in SDK)

Functionality

Enables operations not possible with SQL alone (invites, magic links, MFA)

Accuracy

More reliable then creating and executing raw SQL queries on auth schemas

Simplicity

Offers clear methods with proper validation and error handling