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 build

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["@daitasu/postgres-mcp", "postgresql://user:password@localhost:5432/database"]
    }
  }
}

{
  "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/database

Input: { "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

# Development mode
pnpm run dev

# Tests
pnpm test

# Type checking
pnpm run typecheck

# Lint
pnpm run lint