MCPs tagged with # SQL

Provides standardized MCP server capabilities for analyzing, linting, and converting SQL queries across multiple dialects using SQLGlot. Supports syntactic validation, dialect transpilation, extraction of table and column references, and offers tools for understanding query structures. Facilitates seamless workflow integration with AI assistants through a set of MCP tools.

• ⭐ 26
• MCP
• j4c0bs/mcp-server-sql-analyzer

BigQuery MCP Server provides a Model Context Protocol-compliant interface that allows large language models to inspect database schemas and execute SQL queries on BigQuery. It exposes tools for executing queries, listing tables, and describing table schemas, supporting both CLI and environment-based configuration. The server integrates with Claude Desktop and can be easily installed via Smithery, facilitating seamless interaction between LLMs and BigQuery data sources.

• ⭐ 120
• MCP
• LucasHild/mcp-server-bigquery

Implements a Model Context Protocol (MCP) server for DuckDB, allowing structured database interaction via MCP-compliant tools and language models. Offers a unified query tool for executing any SQL statement, with support for read-only mode to ensure data integrity. Flexible configuration options include database path specification and connection management. Easily integrable with applications like Claude Desktop for enhanced local data analysis through LLMs.

• ⭐ 171
• MCP
• ktanaka101/mcp-server-duckdb

Hydrolix MCP Server provides a Model Context Protocol (MCP) interface for executing SQL queries, listing databases, and listing tables on Hydrolix clusters. It ensures safe, read-only data access and includes a standardized health-check endpoint. The server integrates easily with various MCP-compatible clients, supporting multiple authentication methods using either credentials or service account tokens.

• ⭐ 5
• MCP
• hydrolix/mcp-hydrolix

ClickHouse MCP Server provides an MCP-compliant interface for executing SQL queries, listing databases, and managing tables on ClickHouse clusters. It supports both direct ClickHouse connections and embedded chDB engines, offering pagination, filtering, and detailed metadata in responses. Integrated health checks and flexible configuration options make it suitable for a variety of deployment scenarios.

• ⭐ 592
• MCP
• ClickHouse/mcp-clickhouse