SQL Query MCP Server

Example Use Cases

• 1

  Safely query SQL databases without risking data modification.

• 2

  Explore database schemas and relationships to build complex queries.

• 3

  Integration with VS Code and GitHub Copilot for enhanced SQL query assistance.

Description

This MCP server enables secure, read-only querying of SQL Server, MySQL, and PostgreSQL databases using only SELECT statements, preventing any data modification. It runs containerized in Docker for easy deployment and isolation, supports schema discovery and foreign key detection, and integrates seamlessly with VS Code and GitHub Copilot. The server ensures security by blocking all non-SELECT queries and encourages use of read-only database users.