Blog

Connect to your Hosted Dolt Instance to your Agents using MCP

Brian Hendriks
HOSTEDFEATURE RELEASE
5 min read

It has been our thesis that Dolt is the ideal database for agentic workloads. Agents need a database that is version controlled. The ability to branch, and diff allow agentic workflows to work in isolation, and be audited before merging changes back to mainline. Dolt’s git-like collaboration model also allows multiple agents to work concurrently on the same database without stepping on each other’s toes. In August of 2025 we launched Dolt MCP, which is a server that implements Anthropic’s MCP protocol to allow agents to connect to Dolt databases. Today we are excited to announce that you can now enable Dolt MCP on your Hosted Dolt instances to connect them to your agentic workloads.

Enabling Dolt MCP on Hosted Dolt#

Enabling Dolt MCP on your Hosted Dolt instance is easy.
On the settings tab for your Hosted Dolt deployment, you will find a new section called “Enable Dolt MCP server” In this section, you can enable Dolt MCP for your instance, by clicking the “Expose MCP Server” check box. Once enabled Dolt MCP will be installed on your instance and started in a matter of minutes.

MCP Disabled

After enabling Dolt MCP, the section will update to show the details necessary to connect your MCP compatible agent to your Hosted Dolt instance.

MCP Enabled

Connecting to Hosted Dolt MCP#

Dolt MCP server runs on port 8675, and uses steaming HTTP as the transport mechanism. The server requires clients to authenticate using a token. The token is generally passed as a bearer token by client’s that support that authentication mechanism. Dolt MCP also supports passing the token as a query parameter (jwt), for clients that do not support bearer token authentication.

dolt-mcp Database User#

Dolt MCP server connects to your Hosted Dolt database using a special database user named mcp_user. By default this user does not have any privileges on your database. You will need to grant the necessary privileges to this user in order for Dolt MCP to function correctly. The privileges you grant will depend on the operations you want your agent to be able to perform. At a minimum, you will want to grant the mcp_user read privileges on one or more database tables. Here is an example of granting read privileges on a table called tasks within the database my_database:

GRANT SELECT ON my_database.tasks TO 'mcp_user'@'%';

Configuring your MCP Compatible Agent#

The steps necessary to configure your MCP compatible agent are dependent on the agent you are using. Please refer to the documentation for your agent to learn how to configure it to connect to an MCP server running over https.

An example using Claude#

After creating a Hosted Dolt deployment, I enabled the Dolt MCP server by clicking the checkbox on the settings tab. Next, I go back to the main page of the deployment and copy the mysql command line to connect to my database server and run:

>mysql -h"mcp-test.dbs.hosted.doltdb.com" -u"lop887ig4wkov575" -p"LxuVijXyXiC2ZEi5qvvRiBXSi32MbWIi"
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 8.0.33 Dolt

Copyright (c) 2000, 2025, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> GRANT SHOW DATABASES ON *.* TO 'mcp_user'@'%';
Query OK, 0 rows affected (0.032 sec)

mysql> CREATE DATABASE test;
Query OK, 1 row affected (0.107 sec)

Now that we have enabled the Dolt MCP server and granted the necessary privileges to the mcp_user to show databases we will configure Claude to be able to use our MCP server. The claude command line allows us to add a new MCP server like so:

>claude mcp add --transport http dolt-mcp https://mcp-test.dbs.hosted.doltdb.com:8675/mcp \
 --header "Authorization: Bearer eyJhbGciOiJSUzI1NiIsImtpZCI6IjRjZTI1Y2FjLTFkNjEtNGI3My1hMTAwLTRjMDU3MTJhZTIxYSIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiZGVwbG95bWVudE93bmVycy9kb2x0aHViL2RlcGxveW1lbnRzL21jcC10ZXN0Il0sImV4cCI6MTgwMTY4NzcwMCwiaWF0IjoxNzcwMTUxNzAwLCJpc3MiOiJob3N0ZWQuZG9sdGRiLmNvbSIsImp0aSI6ImExMmE5NWQ1LTYxMTctNGNhMy04MmYzLWViN2E4YTUyYmYzOCIsIm9uX2JlaGFsZl9vZiI6ImJoZW5pIiwic3ViIjoiZG9sdC1tY3AifQ.ULqrWUSunAvk-tsgmr1gP4fJG2Hxj9v9ygiZ7lgXAkZ_HxxXxdAkklsYhW6ie4Y2H9nvZs3Ux1tBWajsZHHeeIzUqReNdNve--Ghm3vCNJqn0m67WFdqbeBhDaUuohCkJvBYi7pXspS087VF8s1eKBQnBBJCo-fe1TGycC_00_pilTWww2o9HJjkLLXl73AOR2zTCm3_80Qq_TasrtHtH7c60zLYBQ4Pr1VZSjb8bdjb_euacwgPR_yJlUhZ6lU7kySg1c2Odk-LO1yqiUmGUKTFMxU1gM2zzDyhk-viuF3a8JMxXt5FDVfAzqTqg5Am6tHs8OugVhinWXWpB_nkwA"
 
Added HTTP MCP server dolt-mcp with URL: https://mcp-test.dbs.hosted.doltdb.com:8675/mcp to local config
Headers: {
  "Authorization": "Bearer eyJhbGciOiJSUzI1NiIsImtpZCI6IjRjZTI1Y2FjLTFkNjEtNGI3My1hMTAwLTRjMDU3MTJhZTIxYSIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiZGVwbG95bWVudE93bmVycy9kb2x0aHViL2RlcGxveW1lbnRzL21jcC10ZXN0Il0sImV4cCI6MTgwMTY4NzcwMCwiaWF0IjoxNzcwMTUxNzAwLCJpc3MiOiJob3N0ZWQuZG9sdGRiLmNvbSIsImp0aSI6ImExMmE5NWQ1LTYxMTctNGNhMy04MmYzLWViN2E4YTUyYmYzOCIsIm9uX2JlaGFsZl9vZiI6ImJoZW5pIiwic3ViIjoiZG9sdC1tY3AifQ.ULqrWUSunAvk-tsgmr1gP4fJG2Hxj9v9ygiZ7lgXAkZ_HxxXxdAkklsYhW6ie4Y2H9nvZs3Ux1tBWajsZHHeeIzUqReNdNve--Ghm3vCNJqn0m67WFdqbeBhDaUuohCkJvBYi7pXspS087VF8s1eKBQnBBJCo-fe1TGycC_00_pilTWww2o9HJjkLLXl73AOR2zTCm3_80Qq_TasrtHtH7c60zLYBQ4Pr1VZSjb8bdjb_euacwgPR_yJlUhZ6lU7kySg1c2Odk-LO1yqiUmGUKTFMxU1gM2zzDyhk-viuF3a8JMxXt5FDVfAzqTqg5Am6tHs8OugVhinWXWpB_nkwA"
}
File modified: /Users/brian/.claude.json [project: /Users/brian/dev/claude-test]

We can verify its configuration using claude mcp get:

>claude mcp get dolt-mcp
dolt-mcp:
  Scope: Local config (private to you in this project)
  Status: ✓ Connected
  Type: http
  URL: https://mcp-test.dbs.hosted.doltdb.com:8675/mcp
  Headers:
    Authorization: Bearer eyJhbGciOiJSUzI1NiIsImtpZCI6IjRjZTI1Y2FjLTFkNjEtNGI3My1hMTAwLTRjMDU3MTJhZTIxYSIsInR5cCI6IkpXVCJ9.eyJhdWQiOlsiZGVwbG95bWVudE93bmVycy9kb2x0aHViL2RlcGxveW1lbnRzL21jcC10ZXN0Il0sImV4cCI6MTgwMTY4NzcwMCwiaWF0IjoxNzcwMTUxNzAwLCJpc3MiOiJob3N0ZWQuZG9sdGRiLmNvbSIsImp0aSI6ImExMmE5NWQ1LTYxMTctNGNhMy04MmYzLWViN2E4YTUyYmYzOCIsIm9uX2JlaGFsZl9vZiI6ImJoZW5pIiwic3ViIjoiZG9sdC1tY3AifQ.ULqrWUSunAvk-tsgmr1gP4fJG2Hxj9v9ygiZ7lgXAkZ_HxxXxdAkklsYhW6ie4Y2H9nvZs3Ux1tBWajsZHHeeIzUqReNdNve--Ghm3vCNJqn0m67WFdqbeBhDaUuohCkJvBYi7pXspS087VF8s1eKBQnBBJCo-fe1TGycC_00_pilTWww2o9HJjkLLXl73AOR2zTCm3_80Qq_TasrtHtH7c60zLYBQ4Pr1VZSjb8bdjb_euacwgPR_yJlUhZ6lU7kySg1c2Odk-LO1yqiUmGUKTFMxU1gM2zzDyhk-viuF3a8JMxXt5FDVfAzqTqg5Am6tHs8OugVhinWXWpB_nkwA

Now that we have configured Claude to connect to our Hosted Dolt deployment’s MCP server, we can start using it to interact with our database.

>claude

╭─── Claude Code v2.1.30 ──────────────────────────────────────────────────────╮
│                                                  │ Tips for getting started  │
│                   Welcome back!                  │ Ask Claude to create a n… │
│                                                  │ ───────────────────────── │
│                                                  │ Recent activity           │
│                      ▐▛███▜▌                     │ No recent activity        │
│                     ▝▜█████▛▘                    │                           │
│                       ▘▘ ▝▝                      │                           │
│   Sonnet 4.5 · API Usage Billing · DoltHub Inc   │                           │
│                ~/dev/claude-test                 │                           │
╰──────────────────────────────────────────────────────────────────────────────╯

❯ can you list databases?

⏺ I'll list the databases available in the Dolt server.

────────────────────────────────────────────────────────────────────────────────
 Tool use

   dolt-mcp - list_databases() (MCP)
   Lists all databases in the Dolt server.

 Do you want to proceed?
 ❯ 1. Yes
   2. Yes, and don't ask again for dolt-mcp - list_databases commands in /Users/brian/dev/claude-test
   3. No

⏺ I'll list the databases available in the Dolt server.
  ⎿  Database
     ---
     test
     information_schema
     mysql

⏺ The Dolt server has the following databases:

  - test - A user-created database
  - information_schema - System database containing metadata about the database server
  - mysql - System database for MySQL compatibility

  These are system databases. There are currently no user-created databases in
  the Dolt server. Would you like to create a new database?

This small example demonstrates just a single interaction with the Dolt MCP server with just one of many agentic platforms that support MCP. The Dolt MCP server provides the full range of Dolt functionality (Just make sure your mcp_user has the necessary privileges).

Conclusion#

We are excited to bring Dolt MCP to Hosted Dolt users. We believe that Dolt is the ideal database for agentic workloads, and we are committed to making it easy for developers to use Dolt in their agentic applications. We look forward to seeing the innovative applications that developers will build using Hosted Dolt and Dolt MCP. We’d love to hear your feedback. Please reach out to us on our Discord.

Blog