CoreMCP bridges legacy SQL databases to AI agents via MCP
CoreMCP is an open-source Go-based MCP server that exposes SQL databases — currently MSSQL and PostgreSQL — as MCP tools and prompts for LLM-driven data analysis.
Score breakdown
CoreMCP provides a ready-made bridge for connecting legacy on-premises SQL databases — including SQL Server 2000+ — to MCP-compatible AI agents without requiring custom integration work.
- 01CoreMCP is an open-source MCP server written in Go that exposes SQL databases as MCP tools and prompts for AI agents.
- 02Ships as a single static binary with embedded drivers; no external runtime required.
- 03Supports stdio transport (e.g., Claude Desktop) and outbound WebSocket for remote/NAT operation.
CoreMCP is an open-source MCP server, written in Go and published by CoreBaseHQ, that exposes SQL databases as MCP tools and prompts for use with LLM-based agents. It compiles to a single static binary with embedded drivers, requiring no external runtime dependencies. It supports two transport modes: stdio for local MCP clients such as Claude Desktop, and an outbound WebSocket for remote operation behind NAT.
The stable feature set includes MSSQL (SQL Server 2000+) and PostgreSQL adapters, schema discovery, custom tools, NOLOCK and Turkish normalization middleware, and WebSocket connect mode.
The stable feature set includes MSSQL (SQL Server 2000+) and PostgreSQL adapters, schema discovery, custom tools, NOLOCK and Turkish normalization middleware, and WebSocket connect mode. A Firebird adapter is in progress (the factory currently returns a placeholder error), while MySQL, HTTP transport, an audit log, and a query result cache are listed on the roadmap. Pre-built binaries are available for `linux/amd64`, `linux/arm64`, `darwin/{amd64,arm64}`, and `windows/amd64`.
Security defaults are conservative: CoreMCP operates in SELECT-only mode unless `readonly: false` is explicitly set in the source config, and even then the project recommends using a dedicated database user with only the minimum necessary permissions — SELECT and EXECUTE only on intended procedures — as defense in depth beyond the server-side guard.
Key facts
- 01CoreMCP is an open-source MCP server written in Go that exposes SQL databases as MCP tools and prompts for AI agents.
- 02Ships as a single static binary with embedded drivers; no external runtime required.
- 03Supports stdio transport (e.g., Claude Desktop) and outbound WebSocket for remote/NAT operation.
- 04Stable adapters: MSSQL (SQL Server 2000+, Turkish_CI_AS collation aware) and PostgreSQL.
- 05Firebird adapter is in progress; MySQL, HTTP transport, audit log, and query result cache are on the roadmap.
- 06Read-only by default — `readonly: false` must be explicitly set to enable stored procedure execution.
- 07Pre-built binaries available for Linux, macOS, and Windows on amd64 and arm64.
Topics
Summary and scoring are generated automatically from the original article. We always link back to the publisher and never republish images or paywalled content. Last processed Jun 16, 2026 · 23:11 UTC. How this works →