Advertise
MCP.so
Sign In

SQL MCP Server (TypeScript)

@MCP-Mirror

Repository

Basic information

Category

Databases

Transports

stdio

Author

MCP-Mirror

About SQL MCP Server

Mirror of

#sql#mcp#typescript#database#server

SQL MCP Server 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>"
      ]
    }
  }
}

SQL MCP Server tools

1

Run a read-only SQL query

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

Frequently asked questions

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.

Comments

More Databases MCP servers

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

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

Advertise