Skip to main content
Glama
call518

MCP PostgreSQL Operations

get_table_list

Retrieve a list of all tables with schema, owner, type, and size information from a PostgreSQL database to understand its structure and contents.

Instructions

[Tool Purpose]: Retrieve list of all tables and their information from specified database (or current DB)

[Exact Functionality]:

  • Retrieve list of all tables in specified database

  • Display schema, owner, and size information for each table

  • Distinguish table types (regular tables, views, etc.)

[Required Use Cases]:

  • When user requests "table list", "table listing", "schema info", etc.

  • When need to understand structure of specific database

  • When table size or owner information is needed

[Strictly Prohibited Use Cases]:

  • Requests for data inside tables

  • Requests for table structure changes or creation/deletion

  • Requests for detailed column information of specific tables

Args: database_name: Database name to query (uses currently connected database if omitted)

Returns: Table-format information including table name, schema, owner, type, and size

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
database_nameNo

Latest Blog Posts

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/call518/MCP-PostgreSQL-Ops'

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