MCPs tagged with # SQL Automation

XiYan MCP Server is a Model Context Protocol (MCP) compliant server that allows users to query SQL databases such as MySQL and PostgreSQL using natural language. It leverages the XiYanSQL model, providing state-of-the-art text-to-SQL translation and supports both general LLMs and local deployment for enhanced security. The server lists available database tables as resources and can read table contents, making it simple to integrate with different applications.

• ⭐ 218
• MCP
• XGenerationLab/xiyan_mcp_server

PGMCP enables seamless interaction with any PostgreSQL database through natural language queries, translating user intent into structured SQL results. It acts as a Model Context Protocol (MCP) server, connecting AI assistants and MCP-compatible clients to databases with features like streaming, robust error handling, and optional AI-powered SQL generation. The tool ensures secure, read-only access to existing databases using HTTP/MCP protocol. Compatibility includes tools such as Cursor, Claude Desktop, and VS Code extensions.

• ⭐ 499
• MCP
• subnetmarco/pgmcp

BigQuery MCP Server acts as a bridge between large language models and Google BigQuery, allowing natural language interactions with database data through the Model Context Protocol. Designed for integration with Claude Desktop, it securely processes user queries and translates them into SQL, streamlining data access and minimizing manual query writing. The tool ensures safe and read-only data operations, supports both tables and materialized views, and labels resource types for easier exploration. Installation is possible via Smithery or manual setup, with a focus on developer-friendliness and robust authentication options.

• ⭐ 129
• MCP
• ergut/mcp-bigquery-server