# PostgreSQL MCP Server (Agent-Architected)

A high-performance **Model Context Protocol (MCP)** server built through recursive agentic development. This server provides Claude and other MCP clients with secure, direct access to PostgreSQL databases.


### The "Meta" Development Story
This project was not manually coded in the traditional sense. It was **"given birth"** by utilizing a **Windows MCP Server** as an autonomous developer. 

By acting as the Lead Architect, I provided high-level technical requirements and structural logic to the Windows MCP agent, which then autonomously:
1.  Generated the Node.js environment and dependency tree.
2.  Implemented the PostgreSQL connection pooling logic.
3.  Architected the MCP tool definitions for database interaction.
4.  Refined and debugged the syntax to produce a production-ready server.

This demonstrates a shift from manual implementation to **Agentic Orchestration.**

### Key Features

* ** Smart Query Execution:** Run optimized `SELECT` queries directly through the LLM interface.
* ** Data Modification:** Execute `INSERT`, `UPDATE`, and `DELETE` statements safely.
* ** Schema Exploration:** Instantly list tables and inspect complex structures/constraints.
* ** Connection Pooling:** Robust management via high-performance pooling for efficiency.
* ** Seamless Config:** Quick-start setup using environment variables and `.env` support.

### Integration with Claude Desktop

To empower Claude with database access, add this server to your configuration file:

* **Windows:** `%APPDATA%\Claude\claude_desktop_config.json`
* **macOS:** `~/Library/Application Support/Claude/claude_desktop_config.json`

```json
{
  "mcpServers": {
    "postgres": {
      "command": "node",
      "args": ["/absolute/path/to/src/index.js"],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "5432",
        "DB_NAME": "your_database",
        "DB_USER": "your_username",
        "DB_PASSWORD": "your_password"
      }
    }
  }
}