Postgres MCP

MIT License

1,059

Overview InspectNew Endpoints Schema Related Servers Reviews Score

list_objects

Retrieve a list of objects, such as tables, views, sequences, or extensions, within a specified schema using this tool. Streamline schema exploration and data management for Postgres MCP workflows.

Instructions

List objects in a schema

Input Schema

Name	Required	Description	Default
`object_type`	No	Object type: 'table', 'view', 'sequence', or 'extension'	table
`schema_name`	Yes	Schema name

Input Schema (JSON Schema)

{
  "properties": {
    "object_type": {
      "default": "table",
      "description": "Object type: 'table', 'view', 'sequence', or 'extension'",
      "title": "Object Type",
      "type": "string"
    },
    "schema_name": {
      "description": "Schema name",
      "title": "Schema Name",
      "type": "string"
    }
  },
  "required": [
    "schema_name"
  ],
  "title": "list_objectsArguments",
  "type": "object"
}

This server cannot be installed

Related Tools

get_object_details
@crystaldba/postgres-mcp
list_tables
@Maxim2324/mcp-server-test
list_tables
@MadeByNando/mcp-postgres-server
list_schemas
@Maxim2324/mcp-server-test
list_tables
@sbfulfil/pg-mcp
list_schemas
@MadeByNando/mcp-postgres-server

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/crystaldba/postgres-mcp'

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