Skip to main content
Glama

Supabase MCP Server

Apache 2.0
782
  • Apple
  • Linux

get_tables

Retrieve detailed metadata, row counts, and sizes for all tables, views, and foreign tables in a specified PostgreSQL schema on Supabase. Supports safe read operations for database inspection.

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

NameRequiredDescriptionDefault
schema_nameYes

Input Schema (JSON Schema)

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

Other Tools from Supabase MCP Server

Related Tools

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/alexander-zuev/supabase-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server