dolthub/dolt-mcp

A Model Context Protocol (MCP) server that provides AI assistants with direct access to Dolt and DoltgreSQL databases. This server enables AI tools like Claude to interact with Dolt's version-controlled SQL databases over either the MySQL or PostgreSQL wire protocol, allowing for database operations, version control workflows, and data management tasks.
Overview
The Dolt MCP Server acts as a bridge between AI assistants and Dolt databases, exposing a comprehensive set of tools for:
- **Database Management**: Create, drop, and manage databases
- **Table Operations**: Create, alter, drop, describe, and query tables
- **Version Control**: Branch management, commits, merges, and diffs
- **Data Operations**: Insert, update, delete, and query data
- **Remote Operations**: Clone, fetch, push, and pull from remote repositories
Both Dolt (MySQL-compatible) and DoltgreSQL (PostgreSQL-compatible) backends are supported. The SQL dialect is selected at startup with the --dolt or --doltgres flag. An embedded DoltLite backend (--doltlite) is also available in specially built binaries, running against a local database file with no server at all — see DoltLite Mode.
Installation
Prerequisites
- Go 1.25 or later
- A running Dolt or DoltgreSQL SQL server instance (not needed for DoltLite mode)
Building from Source
The default build is pure Go (no cgo) and cross-compiles freely:
Binaries built this way do not include DoltLite support (--doltlite returns an error). Building with embedded DoltLite requires cgo and libdoltlite; see Building with DoltLite Support.
Docker Installation
Pull the official Docker image:
Usage
The Dolt MCP Server can run in two modes and supports multiple deployment methods:
Docker Usage (Recommended for Production)
HTTP Server with Docker
Stdio Server with Docker
Connecting to DoltgreSQL from Docker
Set MCP_DIALECT=doltgres to point the container at a DoltgreSQL server. DOLT_PORT defaults to 5432 when the dialect is doltgres.
Native Binary Usage
1. Stdio Server (Recommended for AI Assistants)
The stdio server communicates over standard input/output, making it ideal for integration with AI assistants like Claude Desktop.
Against Dolt (MySQL dialect, the default):
Against DoltgreSQL (PostgreSQL dialect):
If --port is omitted, it defaults to 3306 for Dolt and 5432 for DoltgreSQL.
Claude Desktop Configuration
Add this configuration to your Claude Desktop MCP settings:
For a DoltgreSQL backend, swap --dolt for --doltgres and adjust the port/user to match your server.
HTTP Client Configuration
When connecting to a Dolt MCP server running in HTTP mode, you can configure Claude to use the HTTP transport. **Important**: HTTP connections require the /mcp endpoint to be appended to the server URL.
Using Claude CLI
Claude Desktop Configuration
Add this configuration to your Claude Desktop MCP settings:
**Note**: Replace your-dolt-host, the port, and with your actual server details. The /mcp endpoint is required for HTTP connections.
2. HTTP Server
The HTTP server exposes a REST API for MCP tool calls, useful for web applications and custom integrations.
Pass --doltgres in place of --dolt to connect to a DoltgreSQL server.
DoltLite Mode (Embedded)
DoltLite is a fork of SQLite that adds Dolt's version control features: an entire version-controlled database — branches, commits, diffs, merges, and remotes — lives in a single local file. In DoltLite mode the MCP server embeds the database engine directly, so there is no Dolt or DoltgreSQL server to install, configure, or run: point the server at a database file (created on first use if missing) and start working. This makes it ideal for local-first AI workflows on a laptop or in a container.
DoltLite mode requires a binary built with DoltLite support. Prebuilt archives named dolt-mcp-server-doltlite- are attached to releases for Linux and macOS on amd64/arm64, plus Windows x64, and the multi-architecture dolthub/dolt-mcp: -doltlite Docker images include it. The default (pure Go) build does not: passing --doltlite to it errors with this binary was built without DoltLite support; rebuild with -tags "doltlite libsqlite3" ....