Awesome MCPDatabases

ktanaka101/mcp-server-duckdb

⭐ 178 Python added to this list on 2025-03-09 repository created 2024-11-30

mcp-server-duckdb is a Model Context Protocol server implementation for DuckDB, the embedded analytical database, aimed at local data analysis driven by a language model. The design is deliberately minimal: instead of many specialised endpoints the server exposes one tool, query, which takes any valid DuckDB SQL statement as a string and returns the result rows as text, or a success message for statements such as CREATE and INSERT. The authors argue that modern models can already generate the right SQL for selects, joins, table creation and schema inspection, so separate tools for each operation add no value. No custom MCP resources or prompts are implemented. Configuration is short. The required db-path parameter points at the DuckDB database file, and the server creates the file and any missing parent directories automatically. The optional readonly flag opens the database with read_only set, which enforces DuckDB native read-only protection so the model cannot run CREATE, INSERT, UPDATE or DELETE; in that mode a missing database file is not created and the server fails to start instead. A second optional flag, keep-connection, reuses a single DuckDB connection for the whole server lifetime, which enables temporary objects and slightly faster queries at the cost of holding an exclusive lock on the file. The package is published on PyPI, installs for Claude Desktop through Smithery, and is normally launched with uvx from the mcpServers block of the Claude Desktop configuration file on macOS or Windows. Development needs Python with the uv package manager, the DuckDB Python package and the MCP server dependencies. Because MCP servers communicate over stdio, the README recommends debugging with MCP Inspector, which shows request and response traffic, tool execution, server state and errors.

https://github.com/ktanaka101/mcp-server-duckdb

mcpmcp-serverduckdbdatabasesqlanalyticspythonread-only

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.