Awesome MCPDatabases

julien040/anyquery

⭐ 1774 Go added to this list on 2025-04-09 repository created 2024-04-06

Anyquery is an extensible SQL query engine designed to enable querying across a wide variety of data sources and applications using SQL. It supports querying files, databases, and applications such as Apple Notes, Notion, Chrome, and Todoist, among others. Built on top of SQLite, Anyquery extends its capabilities through a plugin system that allows integration with numerous data sources and functionalities. A key feature of Anyquery is its ability to connect to large language models (LLMs) like ChatGPT, Claude, Cursor, and TypingMind using the Model Context Protocol (MCP). This connection allows LLMs to access and query data through Anyquery, providing contextual data interaction. Anyquery can also operate as a MySQL server, enabling users to run SQL queries from any MySQL-compatible client such as TablePlus or Metabase. The project offers comprehensive documentation and multiple installation options including Homebrew, APT, YUM/DNF, Scoop, Winget, and Chocolatey, making it accessible across various platforms. The plugin-based architecture allows users to install official plugins or create their own, and it supports loading any SQLite extension to further enhance functionality. The core engine is licensed under AGPLv3, while the RPC library uses the MIT license, and plugins have individual licenses. Anyquery is actively maintained with a focus on minor contributions and community feedback. Overall, Anyquery provides a powerful and flexible SQL querying environment that bridges traditional data querying with modern AI-driven data access through MCP, making it a versatile tool for developers and data professionals.

https://github.com/julien040/anyquery

agplv3aiai-integrationanalyticsanyqueryapiapple-notesapplicationsapplications-integrationbusiness-intelligencechatgptchromeclaudecommand-line-interfacecsvcursordata-queryingdata-sourcesdata-visualizationdatabasedatabasesextensiblefilesgithubgojsonlarge-language-modelsllmllm-integrationllmsmcpmetabasemit-licensemodel-context-protocolmysqlmysql-compatible-clientmysql-compatible-clientsmysql-servernotionopen-sourceparquetplugin-basedpluginsquerying-data-sourcesrpc-librarysalesforcesqlsql-query-enginesqlitesqlite-extensionstableplustodoisttypingmind

Also in Databases

dolthub/dolt

Dolt is a SQL database with Git-like version control capabilities, enabling users to manage, version, and collaborate on data and schemas as easily as code in Git repositories.

t8y2/dbx

DBX is a lightweight, cross-platform database client supporting over 70 databases, featuring a built-in AI assistant, MCP Server, and available as desktop, Docker, or CLI.

Canner/WrenAI

Open-source generative BI engine that exposes governed text-to-SQL, a semantic layer and dashboard generation to AI agents through an MCP server and CLI across more than twenty data sources.

googleapis/mcp-toolbox

MCP Toolbox for Databases is an open-source Model Context Protocol (MCP) server that connects AI agents, IDEs, and applications directly to enterprise databases, offering both pre-built and custom ...

makenotion/notion-mcp-server

The Notion MCP Server is an official MCP server implementation that enables secure, programmatic interaction with Notion content through MCP commands, optimized for AI agents and supporting multiple deployment options.

bytebase/dbhub

DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface, enabling MCP clients to connect to and explore multiple database systems including MySQL, PostgreSQL, Oracle, SQL Server, MariaDB, and SQLite.

crystaldba/postgres-mcp

Postgres MCP Pro is an open-source Model Context Protocol server for PostgreSQL that provides advanced database health monitoring, index tuning, query plan analysis, and safe SQL execution to support AI agents and developers throughout the application lifecycle.

supabase-community/supabase-mcp

Supabase MCP Server connects Supabase projects to AI assistants using the Model Context Protocol, enabling LLMs to manage and query Supabase resources.