mcp-server-starrocks (sirjebbington/mcp-server-starrocks) is an MCP server listed on the M8ven Trust Index. It scores 73 out of 100, grade C. It declares 11 tools. No publisher has claimed this listing.

Back to MCP Trust IndexM8ven
C
Caution
73/100

mcp-server-starrocks

→ sirjebbington/mcp-server-starrocks· listed on github_repo_search

Caution. Specific findings reduced this grade. They are listed on the page. Grades reflect the full trust pyramid: code, verification depth, and reputation. New projects cap at C until adoption is earned.

How we verified

⚡ Live Monitored: not connected

Verified is a snapshot. Live keeps it current, and builds your track record.

⚡ Connect GitHub → continuous verification on every pushwhy connect →

Who stands behind it

sirjebbington

Source: github_repo_search

Is this your MCP?

Claim it to get a verified publisher badge, a free copy of our full audit findings, and direct contact for any high-priority issues we find. Or connect your repo for our deepest verification, Live Monitored: read-only, revoke anytime. What we access →

⚡ Connect GitHub for Live Monitored

Install from

GitHub

The grade above is for the source repository. Registries can serve a different version, so we mark the ones we were not able to read.

// key findings
⚠️
Tool descriptions don’t match what handlers do
1 tool describes read intent but its handler mutates — query_and_plotly_chart (line 626: fig : plotly.graph_objs.Figure = eval(plotly_expr, {"px": px}, local_vars))
✅
No credential exfiltration, no sensitive file access, no obfuscation
Static analysis found nothing flowing your secrets to unexpected places.
✅
Open source with a license and README
Anyone can audit the code, the license is declared, and the publisher documents what it does.
🔐
You'll be asked for 2 credentials: STARROCKS_SSL_KEY, STARROCKS_PASSWORD
These are read from process.env at runtime. Make sure you trust where they’ll be sent.
// tools this server exposes11 tools

These names and descriptions are the publisher's own, read from the source code. We print them as written. Our assessment is the findings above, not this list.

read_query

Execute a SELECT query or commands that return a ResultSet. Set output_file to write the full result to disk instead of returning it inline (useful for large results).

write_query

Execute a DDL/DML or other StarRocks command that do not have a ResultSet

analyze_slow_queries_topn

Analyze top N slowest queries and identify performance bottlenecks

analyze_query

Analyze a query and get analyze result using query profile

collect_query_dump_and_profile

Run a query to get it's query dump and profile, output very large, need special tools to do further processing

top_hot_tables

Get top hot tables by audit-log visit count

top_bad_tables

Get top bad tables by table health score

query_and_plotly_chart

using sql `query` to extract data from database, then using python `plotly_expr` to generate a chart for UI to display

table_overview

Get an overview of a specific table: columns, sample rows (up to 3), and total row count. Uses cache unless refresh=true

db_summary

Quickly get summary of a database with tables' schema and size information

set_session_db

Set or clear the default database for THIS MCP session. Subsequent tool calls without an explicit `db` argument will use this database. Pass an empty string or null to clear and fall back to the server's global default. Returns the new effective default for this session.

// environment variables
To run this server yourself, you supply these values. They go in your own MCP client configuration and stay on your machine. The secret label means the value is sensitive, not that the server mishandles it.
configLOG_LEVEL
configSTARROCKS_OVERVIEW_LIMITThe environment variable provides a _soft target_ for the maximum length of the overview string generated _per table_ when populating the cache, helping to manage memory usage.
configSTARROCKS_MCP_OUTPUT_DIR
configMCP_TRANSPORT_MODE(Optional) Communication mode that specifies how the MCP Server exposes its services. Available options:
configSTARROCKS_CHART_OUTPUT_DIR
configSTARROCKS_CHART_INCLUDE_PLOTLYJS
configSTARROCKS_CHART_DEFAULT_FORMAT
configSTARROCKS_CORS_ALLOWED_ORIGINS
configSTARROCKS_SSL_CA(Optional) Path to the CA certificate (PEM) used to verify the StarRocks server certificate.
configSTARROCKS_SSL_CERT(Optional) Path to the client certificate (PEM) for mutual TLS (mTLS).
🔐 secretSTARROCKS_SSL_KEY(Optional) Path to the client private key (PEM) for mutual TLS (mTLS).
configSTARROCKS_TLS_VERSIONS(Optional) Comma-separated list of allowed TLS versions, e.g. TLSv1.2,TLSv1.3.
🔐 secretSTARROCKS_PASSWORD(Optional) StarRocks password. Defaults to empty string.
configSTARROCKS_DUMMY_TEST
configSTARROCKS_FE_ARROW_FLIGHT_SQL_PORTFor the high-performance Arrow Flight SQL connection (enabled via ), TLS is controlled separately:
configSTARROCKS_URLA password embedded in wins, including an explicit empty password like user:@host:9030/db.
configSTARROCKS_USER(Optional) StarRocks username. Defaults to root.
configSTARROCKS_HOST(Optional) Hostname or IP address of the StarRocks FE service. Defaults to localhost.
configSTARROCKS_PORT(Optional) MySQL protocol port of the StarRocks FE service. Defaults to 9030.
configSTARROCKS_DB
configSTARROCKS_MYSQL_AUTH_PLUGIN
configSTARROCKS_POOL_SIZE
configSTARROCKS_CONNECTION_TIMEOUT
configSTARROCKS_USE_PURE
configSTARROCKS_QUERY_TIMEOUT
configSTARROCKS_PASSWORD_FILESTARROCKS_PASSWORD_KEYCHAIN_SERVICE: (Optional, macOS only) Generic password service name to use when reading the password from Keychain. This is only used when no explicit password or is configured.
configSTARROCKS_PASSWORD_KEYCHAIN_SERVICE(Optional, macOS only) Generic password service name to use when reading the password from Keychain. This is only used when no explicit password or STARROCKS_PASSWORD_FILE is configured.
configSTARROCKS_PASSWORD_KEYCHAIN_ACCOUNT(Optional, macOS only) Generic password account name to use when reading the password from Keychain. Defaults to the resolved StarRocks user.
// quality suggestions

Tool annotations

No tools have read-only/destructive annotations

Add readOnlyHint or destructiveHint annotations to every tool so hosts can warn users before invoking.

All four hints declared on every tool

11/11 tools missing one or more hints — read_query (missing: readOnlyHint, destructiveHint, idempotentHint, openWorldHint); write_query (missing: readOnlyHint, destructiveHint, idempotentHint, openWorldHint); analyze_slow_queries_topn (missing: readOnlyHint, destructiveHint, idempotentHint, openWorldHint), +8 more. OpenAI's directory rejects tools where any of the four hints are missing or non-boolean.

For every tool, set all four hints (readOnlyHint, destructiveHint, idempotentHint, openWorldHint) to explicit true/false values that match the handler’s actual behaviour.

Descriptions match behaviour

1 tool describes read intent but its handler mutates — query_and_plotly_chart (line 626: fig : plotly.graph_objs.Figure = eval(plotly_expr, {"px": px}, local_vars))

Rename the tool, rewrite the description, or move the side-effect into a separate clearly-named tool.

Tool test coverage

4/11 tools referenced in tests (36%)

Write tests that reference each tool by name so every tool has at least one test.

Tool description accuracy

query_and_plotly_chart: description implies read-only but handler writes/deletes/executes

Update tool descriptions to accurately reflect all capabilities — especially write, delete, or execute operations.

Claim the listing to review these findings one by one and send us a correction where you disagree, straight to the team. Claiming also means we tell you when the grade moves, and reach you first if we find anything urgent.

// full audit trail
The findings above are the summary. The full trail, every check we ran, each deduction, the network hosts observed and the dependency advisories, goes to verified publishers, along with an alert whenever a new one lands. Verified publishers can also review each finding and dispute it in one click. Publisher corrections have sharpened several of our checks this month, because the maintainer knows the codebase better than any scanner.
// improvement guidance — verified publishers only
We have 5 concrete improvements we can share with the publisher of this MCP. Each comes with specific guidance to raise the trust score.
// embed badge in your README
[![M8ven Verified](https://m8ven.ai/badge/mcp/sirjebbington/mcp-server-starrocks?variant=verified)](https://m8ven.ai/mcp/sirjebbington/mcp-server-starrocks)
Shows verification status without the grade. Want the grade badge instead? Remove ?variant=verified from the URL.
commit: 88e782b0f3ff660c871f47cf8477773ac02d9e92
code hash: cf9419b22e8ff390c0220735a8db0464920c57d18b20a134f64b6f1ba298d367
view raw JSON →
Check MCPs from inside your assistant
Tool Check · MCP

Vetting this one by hand? Tool Check is an MCP that scores other MCPs. Add it once and ask Claude, ChatGPT, or any MCP client to grade a server, surface CVEs, check the publisher, and suggest safer alternatives — before you install.

https://m8ven.ai/api/mcp/tool-check
check_toolsearch_toolscompare_toolsrecommend_alternativescheck_publisherreport_concern
How to add it →Free · no account needed · works in any MCP client