postgreSQL-mcp-server MCP Server

An mcp server that connects to local postgreSQL instances - this is intended as a local development/prototyping aid

Development

Install dependencies:

npm install

Build the server:

npm run build

Run integration test:

npm test

Capabilities

This MCP server provides the following PostgreSQL tools:

Tool	Description
list_tables	List tables in a specified database
execute_query	Execute an arbitrary SQL query
create_database	Create a new database
drop_database	Drop an existing database
create_table	Create a new table with specified columns and constraints
drop_table	Drop a table from a database
create_index	Create an index on specified table columns
drop_index	Drop an index from a table

Installation

To use with Claude Desktop, add the server config:

On MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json On Windows: %APPDATA%/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "postgresql-tools": {
      "command": "node",
      "args": ["/pathtoyourlocalfolder/build/index.js"],
      "env": {
        "POSTGRESQL_HOST": "localhost",
        "POSTGRESQL_PORT": "5432",
        "POSTGRESQL_USER": "adamjackson",
        "POSTGRESQL_PASSWORD": "",
        "POSTGRESQL_DATABASE": "seoanalysis"
      }
    }
  }
}