Schema | mcp-postgresql

mcp-postgresql

Describes the environment variables required to run the server.

Name	Required	Description	Default
`PGSSL`	No	Enable SSL/TLS. Alternative: POSTGRES_SSL.	false
`PGHOST`	No	PostgreSQL host. Alternative: POSTGRES_HOST.	localhost
`PGPORT`	No	PostgreSQL port. Alternative: POSTGRES_PORT.	5432
`PGUSER`	No	Database user. Alternative: POSTGRES_USER.
`PGDATABASE`	No	Default database. Alternative: POSTGRES_DB.	postgres
`PGPASSWORD`	No	Database password. Alternative: POSTGRES_PASSWORD.
`PGPOOL_MAX`	No	Max pool connections.	10
`POSTGRES_DB`	No	Alternative for PGDATABASE.
`POSTGRES_SSL`	No	Alternative for PGSSL.
`POSTGRES_HOST`	No	Alternative for PGHOST.
`POSTGRES_PORT`	No	Alternative for PGPORT.
`POSTGRES_USER`	No	Alternative for PGUSER.
`POSTGRES_PASSWORD`	No	Alternative for PGPASSWORD.
`PGPOOL_IDLE_TIMEOUT_MS`	No	Pool idle timeout in milliseconds.	30000

Features and capabilities supported by this server

Capability	Details
`tools`	{}

Functions exposed to the LLM to take actions

Name	Description
execute_queryA	Executes a SQL query in PostgreSQL and returns rows or affected row count.
list_tablesB	Lists tables in the current database, optionally filtered by schema.
describe_tableA	Returns table structure: columns, types, nullability, defaults, and PK markers.
list_databasesA	Lists all PostgreSQL databases in the server.
get_table_indexesB	Lists indexes for a table with index definition and PK/uniqueness flags.
get_foreign_keysB	Lists foreign keys of a table and their referenced targets.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

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

curl -X GET 'https://glama.ai/api/mcp/v1/servers/ferronicardoso/mcp-postgresql'

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