get_tables
Retrieve detailed schema insights by listing tables, views, and foreign tables, including row counts, sizes, and metadata. Ideal for managing and analyzing PostgreSQL databases in Supabase.
Instructions
List all tables, foreign tables, and views in a schema with their sizes, row counts, and metadata.
Provides detailed information about all database objects in the specified schema:
- Table/view names
- Object types (table, view, foreign table)
- Row counts
- Size on disk
- Column counts
- Index information
- Last vacuum/analyze times
Parameters:
- schema_name: Name of the schema to inspect (e.g., 'public', 'auth', etc.)
SAFETY: This is a low-risk read operation that can be executed in SAFE mode.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema_name | 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
- @crystaldba/postgres-mcp
- @Maxim2324/mcp-server-test
- @crystaldba/postgres-mcp