execute_sql
Run custom SQL queries directly on self-hosted Supabase databases. Supports read-only hints for optimized execution. Ideal for database introspection and management tasks within development environments.
Instructions
Executes an arbitrary SQL query against the database, primarily using the execute_sql RPC function.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| read_only | No | Hint for the RPC function whether the query is read-only (best effort). | |
| sql | Yes | The SQL query to execute. |
Input Schema (JSON Schema)
You must be authenticated.
Other Tools from Self-Hosted Supabase MCP Server
- apply_migration
- create_auth_user
- delete_auth_user
- execute_sql
- generate_typescript_types
- get_anon_key
- get_auth_user
- get_database_connections
- get_database_stats
- get_project_url
- get_service_key
- list_auth_users
- list_extensions
- list_migrations
- list_realtime_publications
- list_storage_buckets
- list_storage_objects
- list_tables
- rebuild_hooks
- update_auth_user
- verify_jwt_secret