get_table_schema
Retrieve detailed schema information for a specific table, including columns, keys, relationships, indexes, constraints, and triggers. This low-risk read operation supports secure database management and integration with Supabase PostgreSQL databases.
Instructions
Get detailed table structure including columns, keys, and relationships.
Returns comprehensive information about a specific table's structure:
- Column definitions (names, types, constraints)
- Primary key information
- Foreign key relationships
- Indexes
- Constraints
- Triggers
Parameters:
- schema_name: Name of the schema (e.g., 'public', 'auth')
- table: Name of the table to inspect
SAFETY: This is a low-risk read operation that can be executed in SAFE mode.
Input Schema
Name | Required | Description | Default |
---|---|---|---|
schema_name | Yes | ||
table | Yes |
Input Schema (JSON Schema)
You must be authenticated.
Other Tools from Supabase MCP Server
Related Tools
- @alexander-zuev/supabase-mcp-server
- @alexander-zuev/supabase-mcp-server
- @alexander-zuev/supabase-mcp-server
- @crystaldba/postgres-mcp
- @Maxim2324/mcp-server-test