Postgres MCP

MIT License

228

Overview InspectNew Schema Related Servers Reviews Score

get_object_details

Retrieve detailed metadata for database objects like tables, views, sequences, or extensions in Postgres MCP by specifying schema and object names for accurate insights.

Instructions

Show detailed information about a database object

Input Schema

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

Input Schema (JSON Schema)

{
  "properties": {
    "object_name": {
      "description": "Object name",
      "title": "Object Name",
      "type": "string"
    },
    "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",
    "object_name"
  ],
  "title": "get_object_detailsArguments",
  "type": "object"
}

You must be authenticated.

Related Tools

list_objects
@crystaldba/postgres-mcp
get_tables
@alexander-zuev/supabase-mcp-server
salesforce_describe_object
@tsmztech/mcp-server-salesforce
get_table_schema
@apache/doris-mcp-server
describe_table
@Maxim2324/mcp-server-test
list_tables
@Maxim2324/mcp-server-test

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