How to Use SingleStore MCP Server with Claude

1. Installing Claude desktop

To use the SingleStore MCP server with Claude, the Claude Desktop application must be installed on your desktop. To do that, go to the official Claude website and download the installer that matches your OS. Once downloaded, follow the standard installation process and open the application. In just a bit, we’ll show you how to configure Claude to work with the SingleStore MCP server.

2. Setting up a local SingleStore MCP server

To make the SingleStore MCP server available to the Claude desktop application, the MCP server must be running locally. Begin by cloning the SingleStore MCP server GitHub repository. In the repository, you can find the server source code, instructions on how to run the server and available tools.

To clone the repository, execute the following command in your terminal:

You can also download the repository as a zip file by clicking on the link.

Once the repository is cloned, open your terminal and change the directory to the cloned repository by executing the following command:

Now we’re at the root of the downloaded server repository, and it's time to create and activate a virtual Python environment to run the server. To do this, simply run the following commands in the terminal:

There are two final things left to complete the SingleStore MCP server setup. First, install the required dependencies by executing the following command:

And finally, run the server by executing:

That's it. The server is now set up, running and ready to handle requests from the Claude desktop client.

3. Connecting Claude desktop to SingleStore MCP server

To connect the installed and opened Claude desktop application to the running SingleStore MCP server, we only need to make one simple settings change. 

Go to the Claude settings, switch to the “Developer” tab and click on the “Edit Config” button.

The Claude folder should be opened, and a claude_desktop_config.json file should be displayed.

Open that file, and insert the following config:

Save the file and reopen the Claude desktop application.

How to get values for env variables

SINGLESTORE_API_KEY

A SingleStore API key is required to use the SingleStore MCP server. To get an API key, go to the SingleStore Portal and on the left sidebar, click on the “API Keys” menu item under the “Configuration” section.

Click on the “Create API Key” button, follow the instructions and copy a generated key.

SINGLESTORE_DB_USERNAME and SINGLESTORE_DB_PASSWORD

These two variables are optional and can be used if you want to access a database in a Claude chat. To get them, navigate to the deployment where the desired database is attached.

Expand the “Connect” drop-down menu, and click on “Your App.”

Copy the values from the “User Credentials” section.

4. Using the SingleStore MCP server in a Claude chat

Now you’re ready to use your running SingleStore MCP server in a Claude chat. Start a new conversation and discover the available tools by clicking on the tools icon.

As an example, let's see how many posts on average have been made in the last three months on the forum in the DB sample.

As we can see, Claude used several tools and we got the following result:

SingleStore continues to evolve into the only platform you need for tasks where scale, performance, low latency and AI capabilities truly matter. The MCP server is another powerful addition built to help you get even more out of your data.

Happy chatting!