PostgreSQL CRUD服务

git clone <repository-url>
cd postgresql-mcp-server

python -m venv venv
source venv/bin/activate  # On Windows: venv\Scripts\activate

pip install -r requirements.txt

# PostgreSQL Configuration
PG_HOST=localhost
PG_PORT=5432
PG_USER=your_username
PG_PASSWORD=your_password
PG_DATABASE=your_database_name

python db/init_db.py

# Run the server directly
python postgres_mcp_server.py

# Or test with the comprehensive client
python client_test.py

# Install the MCP CLI tool (if not already installed)
pip install mcp

# Install your server for Claude Desktop
mcp install postgres_mcp_server.py --name "PostgreSQL CRUD Server"

"Show me all tables in the database"
"Create a new user with name 'John Doe' and email 'john@example.com'"
"Find all products in the 'Electronics' category"
"Update the price of product ID 1 to $999.99"
"Get statistics for the users table"

# Test that the server can start
python postgres_mcp_server.py --help

# Test database connectivity
python db/init_db.py

# Test basic connectivity
python -c "import asyncio; from postgres_mcp_server import main; print('Server can start')"

postgresql-mcp-server/
├── postgres_mcp_server.py    # Main MCP server implementation
├── requirements.txt          # Python dependencies
├── .env.example             # Environment variables template
├── README.md                # This file
├── SETUP_GUIDE.md          # Detailed setup guide
├── LICENSE                 # MIT License
└── db/
    ├── connection.py        # Database connection utilities
    ├── schema.sql          # Database schema and sample data
    └── init_db.py          # Database initialization script

import logging
logging.basicConfig(level=logging.DEBUG)