SQL MCP Server (TypeScript)

@MCP-Mirror

About SQL MCP Server (TypeScript)

Mirror of

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

FAQ from SQL MCP Server (TypeScript)

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

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

Does it support SSH bastion tunnels?

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

What transport protocol does it use?

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

What clients are compatible?

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

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.

Frequently asked questions

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

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

Does it support SSH bastion tunnels?

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

What transport protocol does it use?

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

What clients are compatible?

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

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.

Comments

Basic information

More Databases MCP servers

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245