Supabase MCP Server

by alexander-zuev
Verified
Apache 2.0
649
  • Apple
  • Linux

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

NameRequiredDescriptionDefault
schema_nameYes
tableYes

Input Schema (JSON Schema)

{ "properties": { "schema_name": { "title": "Schema Name", "type": "string" }, "table": { "title": "Table", "type": "string" } }, "required": [ "schema_name", "table" ], "title": "get_table_schemaArguments", "type": "object" }

You must be authenticated.

Other Tools from Supabase MCP Server

Related Tools

ID: cyeeqagb81