Skip to main content
Glama
daitasu

postgres-mcp

by daitasu
OverviewSchemaSourceRelated ServersDiscussionsAdmin
TypeScript
Remote

PostgreSQL MCP Server

Implementation of PostgreSQL Model Context Protocol (MCP) server. Enables read-only SQL query execution and database schema information retrieval.

Features

  • query: Execute read-only SQL queries

  • listTables: Get a list of tables in the database

  • getTableSchema: Get schema information for a specified table

Related MCP server: postgres-mcp

Installation

From npm

npm install -g @daitasu/postgres-mcp

From source

# Clone the repository
git clone https://github.com/daitasu/postgres-mcp.git
cd postgres-mcp

# Install dependencies
pnpm install

# Build
pnpm run build

Configuration

Using npx (Recommended)

Add to your Claude Desktop or MCP client configuration:

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

Using global installation

If you installed globally:

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

Using local installation

{
  "mcpServers": {
    "postgres": {
      "command": "node",
      "args": ["/path/to/postgres-mcp/dist/index.js", "postgresql://user:password@localhost:5432/database"]
    }
  }
}

Command-line execution

# 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

Tool Usage

1. query - Execute SQL queries

Input: { "sql": "SELECT * FROM users LIMIT 10" }
Output: Query results (JSON format)

2. listTables - Get table list

Input: {}
Output: List of table names

3. getTableSchema - Get table schema

Input: { "tableName": "users" }
Output: List of column names and data types

Security

  • All queries are executed within READ ONLY transactions

  • Data modification is not possible

  • Automatically rolled back

Development

# Development mode
pnpm run dev

# Tests
pnpm test

# Type checking
pnpm run typecheck

# Lint
pnpm run lint

License

MIT

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • Postgres MCP Server

    eddykuhan
    F
    license
    Not graded
    quality
    D
    maintenance
    Enables interaction with PostgreSQL databases through MCP, allowing users to explore database structures, inspect table schemas, and execute read-only SQL queries.
    -

  • postgres-mcp

    nicolas-canfrere
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables safe interaction with PostgreSQL databases through read-only queries, schema exploration, and performance analysis.
    152 npm
    MIT