-
securityF
license-
qualityA Model Context Protocol server providing both read and write access to PostgreSQL databases, enabling LLMs to query data, modify records, and manage database schemas.
Last updated -
229
9
Enables direct execution of PostgreSQL queries including SELECT for data retrieval and INSERT, UPDATE, DELETE, CREATE operations for database modifications, returning structured JSON results.
š PostgreSQL MCP Server
A lightweight Model Context Protocol (MCP) server for executing PostgreSQL queries.
This project enables an MCP-compatible client to run SQL queries (both SELECT and non-SELECT) directly on a PostgreSQL database. The server supports both standard input/output and HTTP (REST API) communication modes.
š§© What is MCP (Model Context Protocol)?
MCP is a universal protocol for connecting external tools, data sources, and services to AI models in a standardized way.
Why MCP? MCP eliminates the need for custom integrations per tool, providing a common API for interacting with various resources.
How does this project fit in? This repo gives you an MCP server for PostgreSQL:
Send SQL queries from any MCP-compatible client.
Receive results in structured JSON.
Seamlessly use PostgreSQL as a knowledge base or app datastore.
āØ Features
Execute direct PostgreSQL queries via MCP.
Supports:
Data retrieval:
SELECTqueries return rows.Database changes:
INSERT,UPDATE,DELETE,CREATE, and more return success status.
Dual operation modes:
stdio(standard in/out)http(REST API server)
Structured logging with loguru.
Built for educational, hackable use (not hardened for production).
ā” Requirements
Python 3.9+
A running PostgreSQL database
Dependencies:
psycopg2(SQL driver)loguru(logging)mcp(Model Context Protocol library)
š Project Structure
.
āāā .venv/ # Local virtual environment (should be gitignored)
āāā .gitignore # Ignore rules for git
āāā .python-version # Python version file
āāā code.txt # (Optional: dev notes or scratch work)
āāā main.py # CLI entry point to start the server
āāā pyproject.toml # Project dependencies and metadata
āāā README.md # This documentation file
āāā server.py # PostgreSQL MCP server implementation
āāā uv.lock # Dependency lockfile for reproducible installs
š Setup & Usage
1. Clone the repository
git clone https://github.com/<your-username>/<your-repo-name>.git
cd <your-repo-name>
2. Install dependencies
uv sync
3. Run the server
HTTP mode:
python server.py --mode http --port 9000
Stdio mode (for integration as a tool):
python server.py --mode stdio
š§° Development Notes
All logic is contained in
server.py.main.pyshould be a minimal CLI entry point that parses arguments and starts the server.Feel free to reorganize into a package structure if your codebase grows.
šØāš» Author
Created with ā¤ļø by Loki
š§ Email: logeshwaranshanmugam21@gmail.com
š LinkedIn: Logeshwaran Shanmugam
Tip:
Remember to update your .gitignore to exclude .venv/, __pycache__/, and other cache files for a clean repository.
Happy querying
This server cannot be installed
Related Resources
Related MCP Servers
- AsecurityAlicenseAqualityA Model Context Protocol server that enables powerful PostgreSQL database management capabilities including analysis, schema management, data migration, and monitoring through natural language interactions.Last updated -2,66018944137AGPL 3.0
- -securityAlicense-qualityA Model Context Protocol server that enables interaction with PostgreSQL databases to list tables, retrieve schemas, and execute read-only SQL queries.Last updated -40MIT License
- -securityFlicense-qualityA Model Context Protocol server implementation that provides a simple interface to interact with PostgreSQL databases, enabling SQL queries, database operations, and schema management through MCP.Last updated -