list_extensions

MCP tool from Selfhosted Supabase MCP by HenkDz

Lists installed PostgreSQL extensions

How to use it

list_extensions is exposed by the Selfhosted Supabase MCP MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the list_extensions tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install Selfhosted Supabase MCP

$npx -y @smithery/cli install @HenkDz/selfhosted-supabase-mcp --client claude

FULL SELFHOSTED SUPABASE MCP LISTING

Other tools in Selfhosted Supabase MCP (39)

apply_migration

Applies a SQL migration and records it in supabasemigrations.schemamigrations

create_auth_user

Creates a new user in auth.users (password bcrypt-hashed via pgcrypto)

delete_auth_user

Deletes a user from auth.users

Executes an arbitrary SQL query

Runs EXPLAIN ANALYZE on a query

generate_typescript_types

Generates TypeScript types from the database schema

Retrieves security and performance advisory notices

Retrieves details for a specific user

get_cron_job_history

Shows recent execution history for a cron job

get_database_connections

Shows active connections (pgstatactivity)

get_database_stats

Retrieves database statistics (pgstat)

get_function_definition

Gets the source definition of a function

get_index_stats

Shows index usage statistics

Retrieves recent log entries (analytics stack or CSV fallback)

get_project_url

Returns the configured Supabase URL

Shows RLS enabled/disabled status for tables

get_storage_config

Retrieves storage bucket configuration

get_trigger_definition

Gets the source definition of a trigger

get_vector_index_stats

Shows pgvector index statistics

list_auth_users

Lists users from auth.users

list_available_extensions

Lists all available (installable) extensions

list_constraints

Lists constraints for a specific table

Lists scheduled jobs (requires pgcron extension)

list_database_functions

Lists user-defined database functions

list_foreign_keys

Lists foreign keys for a specific table

Lists indexes for a specific table

list_migrations

Lists applied migrations from supabasemigrations.schemamigrations

list_realtime_publications

Lists PostgreSQL publications (e.g. supabaserealtime)

list_rls_policies

Lists Row-Level Security policies for a table

list_storage_buckets

Lists all storage buckets

list_storage_objects

Lists objects within a specific bucket

list_table_columns

Lists columns for a specific table

Lists tables in the database schemas

Lists triggers for a specific table

list_vector_indexes

Lists pgvector indexes (requires pgvector extension)

Restarts the pgnet worker (if used)

update_auth_user

Updates user details (password bcrypt-hashed if changed)

update_storage_config

Updates storage bucket settings

verify_jwt_secret

Checks if the JWT secret is configured