Loxtep analytics
Skill LoxtepInc/loxtep-plugins-skills/skills/loxtep-analytics
Loxtep plugins and skills for Cursor, Claude, Kiro, Antigravity, and Codex — MCP config and Customer MCPFrom the repository description
npx -y skills add LoxtepInc/loxtep-plugins-skills --skill loxtep-analyticsAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 1 stars1 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
SKILL.md
2.1 KB, as published. Nobody here has run it
Analytics and SQL (Customer MCP)
Story S6: Explore curated mesh data with SQL — discover tables, inspect schema, run queries, fetch results.
When to use
- “Run SQL”, “list tables”, “schema for table”, “execute_query”, “get query results”
Prerequisites
- MCP auth. Operations are organization-scoped in MCP map.
Happy-path flow
loxtep_query→list_tables.get_table_schemafor chosen table(s).execute_querywith the requiredqueryparameter (the SQL text). The required parameter is namedquery, notsql.get_query_resultsif execution is asynchronous or paginated.
MCP mapping
| Step | Tool | operation | Scope |
|---|---|---|---|
| List | loxtep_query | list_tables | organization |
| Schema | loxtep_query | get_table_schema | organization |
| Run | loxtep_query | execute_query | organization |
| Results | loxtep_query | get_query_results | organization |
Pitfalls
- Large result sets — use limits / pagination per platform.
- Wrong org or missing permissions show as auth or empty results.
- Execution environment — Analytics runs against governed mesh tables via
loxtep_query, not an arbitrary external database URL. - Iceberg rebuild — If queries fail with missing parquet / stub schema, use
loxtep_observe→get_iceberg_health, thenrebuild_iceberg_tablewithconfirm: trueandbackfill_from. Alwaysdry_run: truefirst. Never rebuild without explicit confirmation.
Optional attribution
_metadata: { "skill_name": "loxtep-analytics" }
Auth
loxtep-auth / login.