SQL MCP Server (TypeScript)

Name: SQL MCP Server (TypeScript)
Author: t3ta

@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 Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412