{"name":"io.github.startreedata/mcp-pinot","slug":"startreedata-mcp-pinot","title":"Apache Pinot MCP Server","description":"Query and manage Apache Pinot through MCP with typed tools and preview-first safety.","url":"https://mcp.market/server/startreedata-mcp-pinot","rating":null,"grade":"A","score":85,"certified":false,"status":"active","category":"other","tags":[],"presence":{"score":40,"stars":17,"forks":13,"downloads_week":85,"last_push_at":"2026-10-27T10:12:15.000Z","license":"Apache-2.0"},"uptime":null,"claimed":false,"transport":"mixed","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/startreedata/mcp-pinot","website":"https://startreedata.github.io/mcp-pinot/","version":"5.0.0","remotes":[],"packages":[{"registryType":"pypi","registryBaseUrl":"https://pypi.org","identifier":"mcp-pinot-server","version":"5.0.0","transport":{"type":"stdio"},"environmentVariables":[{"description":"HTTP(S) endpoint of the Pinot Controller.","format":"string","default":"http://localhost:9000","name":"PINOT_CONTROLLER_URL"},{"description":"HTTP(S) endpoint of the Pinot Broker.","format":"string","default":"http://localhost:8000","name":"PINOT_BROKER_URL"},{"description":"Optional Pinot basic-auth username.","format":"string","name":"PINOT_USERNAME"},{"description":"Optional Pinot basic-auth password.","format":"string","isSecret":true,"name":"PINOT_PASSWORD"},{"description":"Optional Pinot bearer token. Overrides username and password when set.","format":"string","isSecret":true,"name":"PINOT_TOKEN"},{"description":"Whether to enable Pinot multi-stage query engine support.","format":"boolean","default":"true","name":"PINOT_USE_MSQE"},{"description":"Transport mode: 'stdio' (default, for desktop clients) or 'http'.","format":"string","default":"stdio","name":"MCP_TRANSPORT"},{"description":"Inbound auth provider for HTTP transport (e.g. 'oauth'); required to bind a non-loopback host.","format":"string","name":"AUTH_PROVIDER"}]},{"registryType":"oci","identifier":"ghcr.io/startreedata/mcp-pinot:5.0.0","transport":{"type":"stdio"}}],"tools":[{"name":"begin_investigation","description":"Open an owner-bound, budgeted evidence run using a server-owned profile.","write_action":false,"price_micros":0,"input_schema":null},{"name":"create_schema","description":"Preview or create a new Pinot schema without replacing an existing schema.","write_action":true,"price_micros":0,"input_schema":null},{"name":"create_table_config","description":"Create a new Pinot table configuration.","write_action":true,"price_micros":0,"input_schema":null},{"name":"finish_investigation","description":"Close a run once with authentic citations and an unverified outcome.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_schema","description":"Get one Pinot schema, including dimensions, metrics, time, and primary keys.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_segment_index_metadata","description":"Get per-column index metadata for ONE segment (which indexes each column has).","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_table_config","description":"Get one table's indexing, retention, tenant, and ingestion configuration.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_table_size","description":"Get a table's storage footprint: reported vs. estimated size in bytes.","write_action":false,"price_micros":0,"input_schema":null},{"name":"get_trace","description":"Retrieve scoped trace rows with actual span and parent-span identifiers.","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_segment_metadata","description":"Get a deterministic page of segment rows, sizes, and time boundaries.","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_segments","description":"List a table's segment names, grouped by table type (OFFLINE/REALTIME).","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_tables","description":"List Pinot tables visible to this server (subject to table filters).","write_action":false,"price_micros":0,"input_schema":null},{"name":"query_incident","description":"Collect bounded evidence with fixed tenant/time predicates and citations.","write_action":false,"price_micros":0,"input_schema":null},{"name":"read_query","description":"Run a read-only SQL query against Pinot and return a page of rows.","write_action":true,"price_micros":0,"input_schema":null},{"name":"reload_table_filters","description":"Preview or apply the configured table-filter YAML without restarting.","write_action":false,"price_micros":0,"input_schema":null},{"name":"test_connection","description":"Probe Pinot connectivity and return diagnostics.","write_action":false,"price_micros":0,"input_schema":null},{"name":"update_schema","description":"Update an existing Pinot schema.","write_action":true,"price_micros":0,"input_schema":null},{"name":"update_table_config","description":"Update an existing Pinot table configuration.","write_action":true,"price_micros":0,"input_schema":null}],"scan":{"score":85,"grade":"A","scanned_at":"2026-10-30T06:01:01.800Z","report":{"scannerVersion":"0.1.10","scannedAt":"2026-10-30T06:01:01.757Z","components":{"code":{"score":25,"max":25,"notes":["13 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":15,"max":15,"notes":["last push 3 days ago"]},"identity":{"score":9,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"pypi","identifier":"mcp-pinot-server","version":"5.0.0","found":true,"weeklyDownloads":85,"license":"Apache-2.0","dependencyCount":17,"publishedAt":"2026-10-12T00:58:55.955018Z","repositoryUrl":"https://github.com/startreedata/mcp-pinot.git"}],"repo":{"found":true,"owner":"startreedata","repo":"mcp-pinot","archived":false,"pushedAt":"2026-10-27T10:12:15Z","stars":17,"forks":13,"openIssues":0,"ownerType":"Organization","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/76601333?v=4","ownerCreatedAt":"2020-12-25T23:01:09Z","license":"Apache-2.0"},"icon":{"url":"https://avatars.githubusercontent.com/u/76601333?v=4&s=128","source":"registry","width":128,"height":128},"presence":{"stars":17,"forks":13,"downloadsWeek":85,"license":"Apache-2.0","lastPushAt":"2026-10-27T10:12:15.000Z","score":40}}}},"grade_history":[],"reviews":[]}