Skip to main content
Switching between your AI assistant and AstroBee to check data structures or run queries breaks your flow. With MCP (Model Context Protocol), your AI assistant connects directly to your data layers: so you can explore schemas, run SQL, and get insights without leaving Claude Code, Claude Desktop, or VS Code. MCP is an open standard that lets AI assistants securely connect to external tools and data sources. AstroBee’s MCP server gives your assistant read access to your data layers and the ability to execute queries on your behalf. Always visible in the left sidebar, the MCP page is where you manage these connections.
AstroBee MCP page showing setup instructions for Claude Code and Claude Desktop
Coming soon: An Active Connections table will let you monitor all connected AI assistants, view session details, and track connection status in real time.

Quick setup

  1. Run this command in your terminal:
claude mcp add astrobee --transport http https://agent.production.bumblebee.kurtosis.io/mcp
  1. In Claude Code, type /mcp and select “Authenticate”
  2. Sign in with your AstroBee account in the browser
Learn more about MCP in Claude Code.

Available tools

Once connected, your AI assistant has access to 12 tools for exploring and querying your data.
For editing data layers, use the AstroBee web interface rather than MCP tools. The web interface provides optimized workflows that prevent token overhead and maintain data layer consistency. If you have a specific use case that requires programmatic data layer modifications, contact us at [email protected].

Server & model discovery

ToolDescription
server-statusCheck server health and connection statistics
list-ontologiesList all data layers (semantic models) you have access to
list-source-modelsGet raw data schemas linked to a business model

Entity & property exploration

ToolDescription
list-entitiesList all entities in a model with metadata (optionally with row counts)
list-propertiesGet all properties for a specific entity
describe-propertyGet detailed info about a specific property (type, domain/measure)
list-relationshipsView how entities are connected in a model

Statistics & data quality

ToolDescription
list-entity-statsGet entity-wide metrics (row count, property counts, quality scores)
list-property-statsGet property statistics (uniqueness, null %, distinct counts, samples)

SQL execution

ToolDescription
get-datasource-typeGet the database engine (BigQuery, Postgres, Snowflake) for correct SQL syntax
validate-sqlCheck if a SQL query is syntactically correct without executing
execute-sqlRun a SQL query and get results (up to 1000 rows)

Next steps