MCP.so
Sign In

SQL MCP Server (TypeScript)

@t3ta

Repository

About SQL MCP Server (TypeScript)

No overview available yet

Basic information

Category

Databases

Runtime

node

Transports

stdio

Publisher

t3ta

Config

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

{
  "mcpServers": {
    "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 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.

Comments

More Databases MCP servers

Meilisearch MCP Server

meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.

193

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

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

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

MCP MongoDB Server

kiliczsh

A Model Context Protocol Server for MongoDB

281