LogoSTMCP
Download
dolt-mcp

Dolt MCP Server

A Model Context Protocol server that provides AI assistants with direct access to Dolt databases, enabling database operations, version control workflows, and data management tasks through SQL queries.

Tools

1. list_databases

List all available databases.

2. create_database

Create a new database.

3. drop_database

Remove a database.

4. select_version

Get Dolt server version information.

5. show_tables

List tables in current database.

6. show_create_table

Show table creation SQL.

7. describe_table

Show table schema and structure.

8. create_table

Create new tables.

9. alter_table

Modify table structure.

10. drop_table

Remove tables.

11. query

Execute SELECT queries (read operations).

12. exec

Execute INSERT, UPDATE, DELETE queries (write operations).

13. list_dolt_branches

List all branches.

14. select_active_branch

Show currently active branch.

15. create_dolt_branch

Create new branches.

16. create_dolt_branch_from_head

Create branch from current HEAD.

17. delete_dolt_branch

Remove branches.

18. move_dolt_branch

Rename branches.

19. list_dolt_commits

View commit history.

20. create_dolt_commit

Create commits with staged changes.

21. stage_table_for_dolt_commit

Stage specific tables.

22. stage_all_tables_for_dolt_commit

Stage all modified tables.

23. unstage_table

Remove tables from staging area.

24. unstage_all_tables

Clear staging area.

25. list_dolt_diff_changes_in_working_set

Show uncommitted changes.

26. list_dolt_diff_changes_by_table_name

Show changes for specific table.

27. list_dolt_diff_changes_in_date_range

Show changes within date range.

28. get_dolt_merge_status

Check merge conflicts and status.

29. merge_dolt_branch

Merge branches (fast-forward when possible).

30. merge_dolt_branch_no_fast_forward

Force merge commit.

31. dolt_reset_table_soft

Soft reset specific table.

32. dolt_reset_all_tables_soft

Soft reset all tables.

33. dolt_reset_hard

Hard reset to specific commit.

34. list_dolt_remotes

List configured remotes.

35. add_dolt_remote

Add new remote repositories.

36. remove_dolt_remote

Remove remote repositories.

37. clone_database

Clone remote databases.

38. dolt_fetch_branch

Fetch specific branch from remote.

39. dolt_fetch_all_branches

Fetch all branches from remote.

40. dolt_push_branch

Push branch to remote.

41. dolt_pull_branch

Pull branch from remote.

Open Graph image for Dolt MCP Server

JSON Config

{
  "mcpServers": {
    "dolt-mcp": {
      "command": "/path/to/dolt-mcp-server",
      "args": [
        "--stdio",
        "--dolt-host", "0.0.0.0",
        "--dolt-port", "3306", 
        "--dolt-user", "root",
        "--dolt-database", "your_database_name"
      ],
      "env": {
        "DOLT_PASSWORD": "your_password_if_needed"
      }
    }
  }
}

Useful Links

Information