← all publishers

revosai

@revosai source repo

8 published skills

  1. Query Semantic Model 2 · revosai
    Run a Cube.js query against the semantic model and show the result inline in chat as an ASCII table and (where it makes sense) an ASCII bar chart. Use whenever the user asks a business question that can be answered from the cubes — "how many orders…", "top N…", "revenue by…", "trend over time", "compare X to Y" — or explicitly asks to "query the semantic model", "run a cube query", "show me a chart", "plot…", "graph…". Discovers measures and dimensions via `revos cubes meta`, executes the query with `revos cubes query`, and renders the results without leaving the chat.
    0
    installs
  2. Create Cubes · revosai bundle
    Create first-class Cube.dev cube definitions from existing RevOS dbt gold models. Use when asked to: build a semantic layer, create cubes, generate Cube definitions from dbt, define cube files, or create a semantic model from gold models.
    0
    installs
  3. Query Semantic Model · revosai bundle
    Answer business questions about the org's RevOS data directly in chat by querying its live semantic model over MCP — "how many orders…", "revenue by…", "top N…", "trend over time…", "compare X to Y…" — and schema-discovery questions like "what's in my semantic model", "what can I query", "list cubes/datasets/fields", "describe a cube" — or when explicitly asked to "query the semantic model", "run a cube query", "show me a chart", "plot…", "graph…". Use this whenever you would otherwise call the RevOS api_read tool against the `cubes` resource directly — this skill is what turns its raw JSON into a rendered table, a chart when the shape fits, a safe choice of join path when a query spans multiple cubes, and a plain-English explanation, instead of a dumped tool result. This applies even when the question names a specific source system (HubSpot, Zammad, Exact Online, …) — answer aggregate/analytical questions from the semantic model, not a direct source connector.
    0
    installs
  4. Load Sample Data · revosai
    Populate a BigQuery dataset with sample data from public datasets using bq cp. Use when asked to: load sample data, populate the lakehouse, add demo data, seed the dataset, get started with sample tables, or when the user needs data to explore.
    0
    installs
  5. Explore Lakehouse · revosai
    Inspect the RevOS BigQuery lakehouse: list datasets and tables, introspect table schemas and column types, preview sample rows, assess data layers (bronze/silver/gold), and check data completeness and null rates. Required companion skill for create-dbt-transformations and create-cubes — load before generating dbt models or cube definitions to introspect warehouse columns and types. Use when asked to: explore the lakehouse, list BigQuery tables, inspect a table schema, preview data, check raw source tables, assess data quality, check null rates, understand available data, or perform BigQuery schema introspection.
    0
    installs
  6. Create Connections · revosai bundle
    Create a RevOS Connection YAML that syncs data from a Source into the org's data warehouse. Use whenever the user asks to: add a connection, set up a sync, ingest a table, pipe data from a source, configure streams, pick which tables to ingest, or wire up a Source. The skill picks a sensible stream subset (especially important for databases — most projects don't want every table) and confirms the choice before writing YAML.
    0
    installs
  7. Visualize Semantic Model · revosai bundle
    Generate a model-graph.png visualization of Cube.dev semantic models — render the cube graph, show relationships between cubes, draw the fact spine, or diagram the semantic layer. Use whenever the user mentions visualizing, drawing, diagramming, or graphing the semantic model / cube model / cube relationships, even if they don't explicitly ask for a PNG. Triggers: "visualize the semantic model", "draw the cube graph", "show relationships between cubes", "generate model-graph.png", "diagram the semantic layer", "render the cube model". Accepts an optional folder argument (defaults to `cubes/`).
    0
    installs
  8. Create Dbt Transformations · revosai bundle
    Create new dbt transformations (silver/gold models) in the RevOS dbt project. Use when asked to create a dbt model, build a transformation, add a new layer model, declare a raw source, or register a new raw table. Bronze is source-declarations only — no SQL files. Covers dbt project conventions, sources, materialization, schema.yml, and validation commands.
    0
    installs