Implementation of PostgreSQL Model Context Protocol (MCP) server. Enables read-only SQL query execution and database schema information retrieval.
- query: Execute read-only SQL queries
- listTables: Get a list of tables in the database
- getTableSchema: Get schema information for a specified table
npm install -g @daitasu/postgres-mcp# Clone the repository
git clone https://github.com/daitasu/postgres-mcp.git
cd postgres-mcp
# Install dependencies
pnpm install
# Build
pnpm run buildAdd to your Claude Desktop or MCP client configuration:
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": ["@daitasu/postgres-mcp", "postgresql://user:password@localhost:5432/database"]
}
}
}If you installed globally:
{
"mcpServers": {
"postgres": {
"command": "postgres-mcp",
"args": ["postgresql://user:password@localhost:5432/database"]
}
}
}{
"mcpServers": {
"postgres": {
"command": "node",
"args": ["/path/to/postgres-mcp/dist/index.js", "postgresql://user:password@localhost:5432/database"]
}
}
}# Using npx (no installation required)
npx @daitasu/postgres-mcp postgresql://user:password@localhost:5432/database
# Using global installation
postgres-mcp postgresql://user:password@localhost:5432/database
# Using node directly
node dist/index.js postgresql://user:password@localhost:5432/databaseInput: { "sql": "SELECT * FROM users LIMIT 10" }
Output: Query results (JSON format)
Input: {}
Output: List of table names
Input: { "tableName": "users" }
Output: List of column names and data types
- All queries are executed within READ ONLY transactions
- Data modification is not possible
- Automatically rolled back
# Development mode
pnpm run dev
# Tests
pnpm test
# Type checking
pnpm run typecheck
# Lint
pnpm run lintMIT