# PostgreSQL MCP Server

MCP-compliant server for PostgreSQL database integration with Amazon Q.

## Installation

```bash
pip install -r requirements.txt
```

## Setup

1. **Test connection:**
```bash
python server.py --host host.example.com --port 61025 --database example --username example_user --password example_pwd --test
```

2. **Configure Amazon Q MCP:**

Update `C:\Users\%USERNAME%\.aws\amazonq\mcp.json`:

```json
{
  "mcpServers": {
    "local-postgres-mcp": {
      "command": "C:\\Users\\sk\\AppData\\Local\\Programs\\Python\\Python313\\python.exe",
      "args": [
        "C:\\Workspace\\GitLab\\capacity-planning2\\postgresql-mcp\\server.py",
        "--host", "host.example.com",
        "--port", "61025",
        "--database", "example",
        "--username", "example_user",
        "--password", "example_pwd"
      ],
      "env": {"PYTHONUNBUFFERED": "1"},
      "timeout": 60000
    }
  }
}
```

3. **Restart IntelliJ IDEA** to load the new MCP server

## Using with Amazon Q Chat

Once configured, you can use these commands in Amazon Q chat:

**Query database:**
```
Query the database: SELECT * FROM "capacity_planning2".ports LIMIT 5
```

**List tables:**
```
List all tables in the capacity_planning2 schema
```

**Describe table structure:**
```
Describe the structure of the ports table in capacity_planning2 schema
```

**Browse schemas:**
```
Show me all available database schemas
```

## Available Tools

- **query_database**: Execute SELECT queries with automatic LIMIT
- **describe_table**: Get detailed table column information
- **list_tables**: List tables in specific schema or all schemas

## Security

- Read-only access (SELECT queries only)
- Automatic query limits (100 rows max)
- Connection timeout protection