広告掲載
MCP.so
ログイン

SQL MCP Server (TypeScript)

@MCP-Mirror

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

MCP-Mirror

SQL MCP Server について

Mirror of

#sql#mcp#typescript#database#server

SQL MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

SQL MCP Server のツール

1

Run a read-only SQL query

概要

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 other MCP-compatible clients to query PostgreSQL databases, with optional SSH bastion tunnel support for secure access to private RDS instances. It uses read-only transactions and STDIO-based communication, making it suitable for local, containerized, or AI-driven use cases.

How to use SQL MCP Server (TypeScript)?

Clone the repository, install dependencies with npm install, and build with npm run build. Run the server using npx -y @modelcontextprotocol/server-postgres postgresql://<user>:<pass>@localhost:5433/<dbname>, optionally configuring SSH bastion or direct connection via environment variables or a .env file.

Key features of SQL MCP Server (TypeScript)

  • SSH bastion support for secure private RDS access
  • 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 PostgreSQL databases from AI assistants or MCP-compatible clients
  • Securely access private RDS instances through SSH bastion tunnels
  • Perform read-only database interactions to prevent accidental modifications
  • Integrate with tools like Claude Desktop, Cursor IDE, and Supabase MCP

よくある質問

1

What database engine does SQL MCP Server (TypeScript) support?

It supports PostgreSQL and uses the `pg` library to execute read-only queries.

2

Does it support SSH bastion tunnels?

Yes, it includes SSH bastion support for secure connections to private RDS instances.

3

What transport protocol does it use?

It uses STDIO-based MCP protocol transport for communication with clients.

4

What clients are compatible?

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

5

How do I configure credentials?

Credentials and connection options can be set via a `.env` file or directly as environment variables for PostgreSQL details and SSH bastion configuration.

コメント

「データベース」の他のコンテンツ

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

広告掲載