SQL MCP Server (TypeScript)

@t3ta

关于 SQL MCP Server (TypeScript)

暂无概览

基本信息

分类

数据库

运行时

node

传输方式

stdio

发布者

t3ta

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "sql-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://<user>:<pass>@localhost:5433/<dbname>"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is SQL MCP Server (TypeScript)?

SQL MCP Server (TypeScript) is a TypeScript implementation of a Model Context Protocol (MCP) server that enables language models and MCP-compatible clients to query PostgreSQL databases, including those behind SSH bastion tunnels. It is built for secure, read-only database access, supporting AWS RDS, and communicates via stdin/stdout.

How to use SQL MCP Server (TypeScript)?

Install by cloning the repository and running npm install && npm run build. Configure via .env file or environment variables (e.g., DB_USER, DB_HOST, USE_SSH_TUNNEL). Run the server with npx -y @modelcontextprotocol/server-postgres postgresql://<user>:<pass>@<host>:<port>/<dbname>.

Key features of SQL MCP Server (TypeScript)

🔒 SSH bastion support for secure access to private RDS instances
🐘 PostgreSQL read-only query engine using the pg library
📡 STDIO-based MCP protocol transport
🧠 Compatible with memory-bank-mcp-server
⚙️ Easily configurable via .env or environment variables
🧪 Fully testable with Jest and mocks

Use cases of SQL MCP Server (TypeScript)

Query private PostgreSQL databases in AWS RDS through SSH bastion tunnels
Enable AI assistants (e.g., Claude Desktop) to run read-only SQL queries
Integrate read-only database access into MCP-compatible IDEs like Cursor
Provide secure database querying for language model workflows

FAQ from SQL MCP Server (TypeScript)

What transport protocol does SQL MCP Server (TypeScript) use?

It uses STDIO-based MCP protocol transport.

Can it access private RDS instances behind a bastion host?

Yes, the server supports SSH bastion tunneling for reaching private databases.

Is the query engine read-only?

Yes, it uses a PostgreSQL read-only query engine.

Which clients are compatible with SQL MCP Server (TypeScript)?

It has been tested with memory-bank-mcp-server, Claude Desktop (via STDIO), Cursor IDE, and Supabase with MCP integration.

What are the runtime dependencies?

The server requires Node.js, TypeScript, and the pg PostgreSQL client library. Configuration is handled through .env or environment variables.

评论

数据库分类下的更多 MCP 服务器

MCP MongoDB Server

A Model Context Protocol Server for MongoDB

Postgres Mcp

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

Redis MCP Server

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

Neon MCP Server

MCP server for interacting with Neon Management API and databases