mcp-server-starrocks

Overview

The StarRocks MCP server provides comprehensive database connectivity through the Model Context Protocol. It allows AI assistants to directly execute SQL queries, both read and write operations, explore database schemas, retrieve table overviews, and generate data visualizations using Plotly. The server supports multiple transport modes including stdio and HTTP, with intelligent caching for frequently accessed data. Configuration is flexible, supporting individual environment variables or a connection URL, with optional macOS Keychain integration for secure password management.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• read_query

  Execute a SELECT query or other commands that return a ResultSet.

  Try:Show me all users from the customers tableTry:List the top 10 products by salesTry:Describe the structure of the orders table
• write_query

  Execute DDL or DML commands that don't return a ResultSet.

  Try:Create a new table called user_activityTry:Insert new records into the products tableTry:Drop the temporary_orders table
• analyze_query

  Analyze a query and get analyze results using query profile or explain analyze.

  Try:Analyze the performance of the slow sales report queryTry:Show me the execution plan for this complex join queryTry:Get the profile for query ID abc123
• query_and_plotly_chart

  Execute a SQL query and generate a Plotly chart from the results.

  Try:Create a bar chart showing monthly revenueTry:Plot the distribution of customer agesTry:Show a scatter plot of price vs rating for products
• table_overview

  Get an overview of a specific table including columns, row count, and sample rows.

  Try:Show me an overview of the customers tableTry:Describe the structure and sample data from the orders tableTry:What columns are in the products table?
• db_overview

  Get an overview of all tables within a specified database.

  Try:Show me all tables in the sales databaseTry:What tables are available in the analytics database?Try:List all tables and their basic structure

Comparable tools

Installation

uv add mcp-server-starrocks

{
  "mcpServers": {
    "mcp-server-starrocks": {
      "url": "http://localhost:8000/mcp"
    }
  }
}

uv run mcp-server-starrocks --mode streamable-http --port 8000

FAQ

How do I connect to a password-protected StarRocks database?

You can use the STARROCKS_URL environment variable with format 'user:password@host:port/database' or store the password in macOS Keychain with STARROCKS_PASSWORD_KEYCHAIN_SERVICE.

Can I execute write operations through this MCP server?

Yes, the server supports write_query for DDL (CREATE, ALTER, DROP) and DML (INSERT, UPDATE, DELETE) operations that modify the database.

Compare mcp-server-starrocks with