agiletec-inc/selfhosted-supabase-mcp
If you are the rightful owner of selfhosted-supabase-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
This project provides a Model Context Protocol (MCP) server for self-hosted Supabase instances, enabling seamless interaction with local or privately hosted Supabase projects.
Tools
Functions exposed to the LLM to take actions
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.
get_database_connections
Shows active database connections.
get_database_stats
Retrieves database statistics.
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.
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.
list_auth_users
Lists users from auth.users.
get_auth_user
Retrieves details for a specific user.
create_auth_user
Creates a new user.
delete_auth_user
Deletes a user.
update_auth_user
Updates user details.
list_storage_buckets
Lists all storage buckets.
list_storage_objects
Lists objects within a specific bucket.
list_realtime_publications
Lists PostgreSQL publications.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client