PostgreSQL MCP Server

list_tables

Query and retrieve a list of tables along with their basic details from a PostgreSQL database schema, aiding in database exploration and structure analysis.

Instructions

List all tables in the database with basic information

Input Schema

Name	Required	Description	Default
`schema`	No	Schema name (default: public)	public

Input Schema (JSON Schema)

{
  "properties": {
    "schema": {
      "default": "public",
      "description": "Schema name (default: public)",
      "type": "string"
    }
  },
  "type": "object"
}

This server cannot be installed

Related Tools

get_schema
@melihbirim/pg-mcp
list_tables
@antonorlov/mcp-postgres-server
get-schema
@cesarvarela/postgres-mcp
list_schemas
@antonorlov/mcp-postgres-server
describe_table
@sbfulfil/pg-mcp
list_schemas
@crystaldba/postgres-mcp

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/sbfulfil/pg-mcp'

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