Provides a MySQL-compatible Dolt data store with Git-like versioning, enabling schemas and data operations with safe commits and branches.
Configuration
View docs{
"mcpServers": {
"dolt_sql": {
"command": "dolt",
"args": [
"sql-server"
]
}
}
}Dolt MCP Server lets you run a MySQL-compatible Dolt data store with built-in Git-style versioning. You can start the server locally, connect with any MySQL-compatible client, manage schemas and data, and perform branch-based development with safe commits and history tracking.
You run the Dolt MCP Server locally and connect to it with any MySQL-compatible client. Start the server, then use standard SQL or your Dolt CLI to create schemas, insert data, and commit changes. Use branches to experiment, and merge them back into main when you are ready. You can inspect commit history, view diffs between commits, and rewind or revert changes as needed.
Prerequisites: you only need a supported operating system with a shell. No separate language runtime is required for the server itself.
# Install Dolt server binary (example flow shown here; follow your platform’s preferred method):
# Start from a terminal on Linux or macOS
sudo bash -c 'curl -L https://github.com/dolthub/dolt/releases/latest/download/install.sh | bash'
# Verify installation
dolt versionMCP server configuration in this guide uses a local, stdio-based server start command shown here. The server runs a MySQL-compatible service on port 3306, allowing you to connect with any MySQL client.
{
"mcpServers": {
"dolt_sql": {
"command": "dolt",
"args": ["sql-server"]
}
}
}Start the server, then connect with a MySQL client to localhost at port 3306. You can create databases, tables, and relationships, and Dolt will track changes over time with built-in version control. Use dolt_commit equivalents and dolt_log to review history, and use dolt_reset to undo unintended changes.
Key commands you will use include creating databases, creating tables, inserting data, and committing changes to create a time-traveled history of your dataset. You can also checkout branches to test schema changes in isolation and merge them back into main when ready.
Ensure that you manage access to the server the same way you would with any MySQL-compatible service. If you need to undo changes, you can reset to a known good state or revert specific commits as needed.
Dolt command-line tool with a comprehensive set of version control-like operations for managing SQL tables as Dolt objects.
Stage specified tables for commit, analog to staging files in Git.
Record changes to the repository with a message, creating a Dolt commit.
View the commit history for a Dolt repository.
Show differences between commits or branches for a table.
Create or switch to a branch, enabling isolated work streams.
Merge changes from one branch into another, with conflict resolution support.
Undo changes in progress or rewind to a previous state.