postgres-mcp-server

Dhiraj123-star/postgres-mcp-server

3.2

If you are the rightful owner of postgres-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

An Enhanced Model Context Protocol (MCP) server that integrates PostgreSQL with OpenAI GPT-4o-mini for natural language to SQL query execution.

Tools

Functions exposed to the LLM to take actions

natural_language_query

Ask database questions in plain English.

execute_sql

Run raw SQL queries with safety checks.

get_schema

Fetch schema details for all or specific tables.

validate_sql

Validate SQL queries without execution.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources