All authors
Claude Skills by ai-analyst-lab
github.com/ai-analyst-lab64 skills0 installs98 views
- ArchaeologyRetrieve proven SQL patterns, table cheatsheets, and join patterns from .knowledge/query-archaeology/ so past work gets reused. Fire as a pre-flight step before writing ANY SQL. Also trigger on "do we have a known query for X", "how do we usually join these tables", "have we computed this metric before". If the store is empty or missing, exit silently. Also owns the writer convention: after a validated analysis, curate the final SQL here.Votes: 0GitHub stars: 304
- Archive AnalysisSave completed analyses to the knowledge system's analysis archive for future reference. Use this skill after completing any L3+ analysis, when `/run-pipeline` completes, when the user explicitly says "save this analysis" or "archive this", or automatically at the end of Step 18 (Close the Loop) in the analysis workflow. This skill captures key findings, metrics used, agents invoked, and output file paths so past work can be referenced in future sessions. Trigger whenever you finish validatio...Votes: 0GitHub stars: 304
- BusinessBrowse, search, and explore your organization's business context system — glossary terms, product catalog, metric definitions, OKRs/objectives, and team structure. This skill provides interactive access to all business knowledge stored in `.knowledge/organizations/`. Use this skill whenever the user wants to understand business terminology, look up metric definitions, explore what products exist, review company objectives, understand team structure, search for business terms, or generally wan...Votes: 0GitHub stars: 304
- Close The LoopEnsure every analysis that includes a recommendation ends with a clear, actionable follow-up plan. CRITICAL RULE - Only use this skill AFTER a specific recommendation has been made. Use this skill at the end of ANY analysis that produces a recommendation, action item, suggested fix, proposed investment, or conclusion that says "we should do X." This skill is CRITICAL for turning analytical insights into actual business outcomes — without it, recommendations get forgotten and never evaluated. ...Votes: 0GitHub stars: 304
- Compare DatasetsCompare metrics, findings, and patterns across two or more connected datasets. Helps identify cross-dataset patterns (e.g., "conversion funnel behavior is similar across both product lines") and dataset-specific anomalies. Use this skill whenever the user wants to compare datasets, mentions phrases like "compare datasets", "is this pattern the same across", "how does X differ between datasets", "cross-dataset comparison", "analyze across product lines", "compare metrics between", or asks whet...Votes: 0GitHub stars: 304
- Connect DataGuided wizard to connect a new dataset to the AI Analyst system. Use this skill whenever the user wants to add a new data source, connect a database, set up data access, or configure a new dataset for analysis. This skill handles the full connection workflow: choosing connection type (CSV, DuckDB, PostgreSQL, Snowflake, BigQuery, Databricks, Redshift, SQL Server, MySQL), collecting credentials, validating connectivity, profiling schema, and setting up the knowledge brain. Trigger this skill w...Votes: 0GitHub stars: 304
- Data InspectShow the active dataset's schema — tables, columns, row counts, and relationships. Optionally drill into a specific table. Use this skill whenever the user invokes `/data` or `/data {table}`, or asks questions like "what tables do I have?", "show me the schema", "what's in this dataset?", "what columns are in the users table?", "show me table structure", "list tables", "describe the data", "what's in my database?", or any request to inspect, browse, or understand the structure of the active d...Votes: 0GitHub stars: 304
- Data ProfilingDeep-profile the active dataset: distributions, temporal patterns, correlations, completeness gaps, anomalies. Use after connecting a new dataset. Trigger on "profile this data", "deep-profile the dataset", "run a data profile", "check distributions", "find anomalies in the data", "how complete is this data". For a first-contact overview use data-map; for one column use distribution-profiler; for schema use data-inspect.Votes: 0GitHub stars: 304
- Data Quality CheckValidate data completeness, consistency, and coverage before any analysis, flagging issues with severity ratings. Run at the start of every new analysis. Trigger on "check data quality", "is the data clean", "validate the data", "run a quality check", "what's the coverage", and on named-table questions: "tell me about the {table} table", "describe {table}", "what's in {table}"; pair schema answers with a minimum DQ probe.Votes: 0GitHub stars: 304
- DatasetsList all connected datasets with their status, table counts, and last analysis date. Use this skill whenever the user invokes `/datasets`, or asks questions like "what datasets do I have?", "show me my data sources", "list datasets", "which datasets are connected?", "what data is available?", "show all datasets", "what datasets can I analyze?", "view my datasets", "what data sources are set up?", or any request to see what datasets exist in the system. Also trigger when users mention "switch ...Votes: 0GitHub stars: 304
- ExploreQuick, interactive data exploration without the full pipeline. Use this skill whenever a user wants to explore data, understand what's in a dataset, browse tables or columns, check data distributions, spot patterns, or get familiar with data before analysis. Trigger on phrases like "/explore", "let me explore the data", "what's in this dataset?", "show me what data we have", "browse the data", "what tables are available?", "what columns does X have?", "show me a sample of the data", "what doe...Votes: 0GitHub stars: 304
- ExportExport analysis results in different formats for different audiences — email summaries, Slack updates, decision briefs, Google Docs with embedded charts, Word documents, slide decks, or raw data CSVs. Use this skill whenever someone says `/export`, "export this as...", "send this to...", "share this analysis", "create a Google Doc", "make a Word document", "I need this as a deck", "export the data", "write an email summary", "draft a Slack update", "create a brief", or mentions needing analys...Votes: 0GitHub stars: 304
- ForecastGenerate time-series forecasts and projections for metrics over future time periods. Use this skill whenever the user asks about future values, predictions, or projections — phrases like "what will X look like next month?", "forecast DAU for Q2", "project revenue", "estimate future growth", "what should we expect?", "predict next quarter", "where are we headed?", "extrapolate this trend", or explicitly invokes "/forecast". This skill is essential after trend analysis when you need to quantify...Votes: 0GitHub stars: 304
- GuardrailsEnsure every success metric is paired with guardrail metrics and check for trade-offs before presenting improvements as wins. Guardrails protect against winning the metric game while losing the business game. Apply this skill whenever you define a metric, create a metric spec, document a KPI, report positive findings, present an improvement, analyze metric changes, investigate metric lifts, share good news about metrics, celebrate wins, or present results showing any metric increased. This sk...Votes: 0GitHub stars: 304
- HistoryBrowse and search past analyses from the knowledge system's analysis archive. Use this skill whenever the user invokes `/history` or variants like `/history search=X`, `/history {id}`, `/history --all`, `/history dataset=X`, or asks questions about their analytical work history such as "what have I analyzed before?", "what analyses have I run?", "show me past work", "show my history", "what have we looked at?", "what questions have I answered?", "can I see my analysis history?", "list my anal...Votes: 0GitHub stars: 304
- Knowledge BootstrapInitialize session context, resolve the active dataset and context source, load resident instructions, and inventory the context available for question-specific selection. Run at the start of every session and again after /connect-data or /switch-dataset. Handles missing files gracefully, so running it when unsure is harmless.Votes: 0GitHub stars: 304
- Log CorrectionRecord analyst mistakes, fixes, and reusable learnings so future analyses never repeat an error. Fires automatically when the user corrects work ("actually it's Y", "that's wrong") or teaches a rule ("always use X", "never include test users", "remember that our fiscal year starts in February"), and manually on "log a correction", "save this mistake", "record this lesson". Writes the .knowledge store per docs/KNOWLEDGE.md.Votes: 0GitHub stars: 304
- Metric SpecDefine any metric completely with a standardized template: calculation, denominator, time window, filters, interpretation. Trigger on "define this metric", "how should we measure X?", "what's the right way to calculate Y?", "document our metrics", "create a metric definition", "different teams are measuring this differently", or when a metric is used in analysis without a clear specification.Votes: 0GitHub stars: 304
- MetricsBrowse, search, and display metric definitions from the active dataset's metric dictionary. This skill provides quick access to how metrics are defined, computed, and validated. Use this skill whenever the user wants to see metric definitions, understand how a metric is calculated, check what metrics are available, or verify a metric's specification before using it in analysis. Trigger on phrases like "/metrics", "show me the metrics", "what metrics do we track?", "how is [metric name] calcul...Votes: 0GitHub stars: 304
- PatternsBrowse, search, and leverage recurring analytical patterns discovered across past analyses. Use this skill when users want to see what patterns have emerged from previous work, check if a current finding matches a known pattern, search for patterns by keyword or metric, view pattern details, understand established behavioral patterns in their data, or get reminded of recurring observations at session start. This skill is especially valuable when users say things like "what patterns have we se...Votes: 0GitHub stars: 304
- Question FramingStructure analytical questions with the Question Ladder (Goal, Decision, Metric, Hypothesis), then fill the 7-field Analysis Design Spec, before touching data. Trigger on "analyze", "investigate", "look into", "why did", "what's happening with", "what happened with", "figure out", "explore", "deep dive", "what caused", "compare", "breakdown", "root cause", "show me", "pull", "calculate". Framing first, analysis second.Votes: 0GitHub stars: 304
- Question RouterClassify every analytical request (anything about data, metrics, trends, segments, funnels, revenue, retention, experiments, or "why did X change") into complexity levels L1-L5 and route it before any analytical workflow starts, including follow-ups mid-analysis and chart requests. Simple lookups get a direct answer; investigations get the depth they need. Run this first even when the question looks simple.Votes: 0GitHub stars: 304
- Resume PipelineResume a specifically identified analysis using its verified run-local artifacts and controller state.Votes: 0GitHub stars: 304
- Run PipelinePlan and run coordinated analysis using explicit input bindings, isolated workers, run-local artifacts, and the Python workflow controller.Votes: 0GitHub stars: 304
- RunsBrowse, inspect, compare, and clean up past pipeline runs. This skill is your window into analysis history — every `/run-pipeline` execution creates a tracked run with its own working directory, outputs, and state. Use this skill whenever the user wants to see what analyses have been executed, review past work, compare different approaches to the same problem, or clean up old runs. Trigger on phrases like "/runs", "show me my past analyses", "what pipeline runs do I have?", "list my pipeline ...Votes: 0GitHub stars: 304
- Setup Dev ContextConfigure AI Analyst to understand your development environment and codebase structure. Use this skill whenever developers need to integrate AI Analyst into their workflow, or when questions arise about database configuration, SQL conventions, schema naming patterns, dbt integration, warehouse connections, or team-specific data practices. Trigger this skill when users mention: "set up for our team", "configure for our codebase", "integrate with our database", "tell it about our SQL conventio...Votes: 0GitHub stars: 304
- SetupRun a 4-phase conversational interview that populates the knowledge system from the user's real context. Turns a blank `.knowledge/` directory into a fully configured analytical environment. Use this skill whenever the user wants to set up the AI Analyst, configure their environment, get started with the tool, onboard themselves, connect their data for the first time, initialize their profile, or set up the system. Also trigger when users say things like "let's get started", "I'm new here", "...Votes: 0GitHub stars: 304
- Stakeholder CommunicationAdapt analytical findings to the audience — same insight, different framing, detail level, and format depending on who will read it. Use this skill whenever producing a narrative, creating a deck, writing an executive summary, drafting a report, generating stakeholder communications, or whenever the user mentions an audience (executive, PM, engineer, data scientist, leadership team, stakeholders, decision-makers). Apply when users say things like "prepare this for leadership", "write this for...Votes: 0GitHub stars: 304
- Switch DatasetChange the active dataset to switch between different data sources for analysis. Use this skill whenever the user wants to analyze a different dataset, switch to another database, change data sources, work with different tables, or explicitly invokes /switch-dataset. This skill handles the full switch workflow: validating the target dataset exists, checking for in-progress work that might be lost, updating the active pointer, and confirming the switch with a summary of the new dataset. Apply ...Votes: 0GitHub stars: 304
- Tracking GapsAssess whether the data needed for an analysis actually exists, identify what's missing, and produce prioritized instrumentation requests for engineering when gaps are found. Use this skill whenever you're about to start an analysis, when a user asks about data availability, when you need to check if certain events or properties are tracked, when the Data Explorer agent finds incomplete data, when you're designing an analysis and need to verify data exists, when initial queries return nulls o...Votes: 0GitHub stars: 304
- TriangulationAnalyze one decision through independent methods or sources, compare the paths, and reconcile disagreement. Use when a novel analysis needs corroboration and no single answer key is available.Votes: 0GitHub stars: 304
- Visualization PatternsApply whenever you generate any chart, graph, or data visualization — from SQL results, in the chart-maker agent, in decks, or on "make a chart / visualize / plot / dashboard" requests. Enforces Storytelling With Data: gray first, one focus color, action titles, direct labels, no pies, using the helpers in helpers/viz/chart_helpers.py.Votes: 0GitHub stars: 304
- Always CompareNever present a metric or number in isolation; anchor every number to a comparison (prior period, benchmark, or another segment) or state that none is available. Use every time you show a number: rates, counts, revenue, averages, query results, chart labels, summary stats. Trigger on output containing "the rate is", "we saw", "total", "average", "conversion", "revenue", "users", "sessions", "churn", "AOV", "NPS", or any figure pulled from data.Votes: 0GitHub stars: 304
- Analysis DesignTakes a vague analytical hunch, stakeholder request, or business question and produces a rigorous, stakeholder-ready analysis plan through a multi-stage pipeline. Use this skill whenever someone says "I think X caused Y", "help me investigate...", "design an analysis for...", "can you look into why...", "we need to figure out what's driving...", or presents any analytical question that needs methodological rigor before execution. This skill is essential when a PM has a hunch but no plan, when...Votes: 0GitHub stars: 304
- Analyst CoreOperating rules for every data analysis. Apply for ANY data-analysis intent: "analyze", "investigate", "why did X change", "compare", "report on", "dashboard", "metrics", "funnel", "retention", "revenue", "conversion", "trend", "segment", "forecast", "how are we doing", "dig into", "break down", or any question about data, a metric, a CSV, or a table. Sets the method and routes to the other skills; load before any analytical question.Votes: 0GitHub stars: 304
- Auth PreflightVerify Google Workspace MCP authentication at the start of any session that needs Google APIs (Docs, Slides, Drive). This skill prevents auth failures mid-workflow by testing credentials upfront. Use this skill automatically at session start when the task involves Google Docs, Google Slides, Drive uploads, or any MCP Google Workspace tool. Also trigger when users mention "Google Doc", "Google Slides", "upload to Drive", "export to Google", "share on Drive", or any Google-related output format...Votes: 0GitHub stars: 304
- CausalCausal inference toolkit for when experiments are not possible: estimate treatment effects from observational data with assumption checks and mandatory caveats. Invoke as /causal. Trigger on "causal", "caused", "impact of", "effect of", "attribution", "counterfactual", "difference-in-differences", "DiD", "propensity matching", "pre-post". If randomization IS possible, route to /experiment design instead.Votes: 0GitHub stars: 304
- Chart To DriveStandardized workflow for uploading local chart PNGs to Google Drive and making them available for insertion into Google Docs and Slides. Use this skill whenever you need to insert charts into Google Docs or Google Slides, when the google-doc-creator or google-slides-creator agents need chart URLs, when building presentations or reports with embedded visualizations, when user asks to "upload charts", "add images to the doc", "put charts in slides", "make charts available for Google", or any t...Votes: 0GitHub stars: 304
- Codex ReviewIndependently validate the current analysis with a second model (OpenAI Codex). Codex re-derives the same answer from the same data — blind to Claude's SQL and numbers — and the skill reports AGREE / DISAGREE / PARTIAL per finding. Use when the user types "/codex-review", or says "validate with codex", "codex review", "second opinion from codex", "have the other model check this", "independently verify this analysis", "does codex agree", "cross-check this with gpt/codex", or wants a different...Votes: 0GitHub stars: 304
- Connect SnowflakeQuery the live/remote Snowflake warehouse instead of the local practice copy. Use when the user says "connect to snowflake", "use the live data", "go remote", "query the warehouse", or asks "is this hitting snowflake or duckdb?". Assumes credentials already exist (first-time setup is /setup-snowflake); opts into remote via ConnectionManager and verifies the connection type before any query runs.Votes: 0GitHub stars: 304
- Context CompareAdvanced: runs the same question under two configurations and diffs the results. Ask one analytics question with a piece of context and without it, and measure what changed. Trigger on "/context-compare", "run it with and without <the definition/context>", "does adding <X> change the answer", "is this context worth it".Votes: 0GitHub stars: 304
- Context TraceShow which context the AI analyst would receive for a question, why each item was selected, how it is delivered, and which conflicts, stale items, or omissions need attention. Use when the user asks what context was loaded, why a definition did or did not reach an analysis, what the analyst knows about a question, or invokes /context-trace.Votes: 0GitHub stars: 304
- Data MapProduce a comprehensive cross-table data health map for the active dataset — the full payoff answer to open-ended "tell me about this data" questions. Run all tables, not just one: table inventory with row counts, PK uniqueness, date range per table, date alignment across tables, column completeness, foreign-key join-rate matrix, relationship diagram, and a thread-to-pull opening hypothesis. Use this skill whenever the user asks a **dataset-wide open question** — "tell me about this data", "t...Votes: 0GitHub stars: 304
- Distribution ProfilerSingle-column distribution deep-dive. Profile the statistical distribution of a data column and produce an analytical playbook: distribution identification, valid summary stats, recommended tests, A/B guidance, traps. Trigger on "profile this column", "what distribution is this", "check the distribution", "is this normal", "what test should I use", "check assumptions before A/B test", "how is this data distributed".Votes: 0GitHub stars: 304
- EvalEvaluate a named AI Analyst configuration across a frozen suite. Use when the user asks to run an eval suite, compare a change, inspect system accuracy, or run working or heldout capability and regression cases.Votes: 0GitHub stars: 304
- Evaluate GraderCompare a narrow model grader with frozen human labels and inspect disagreement, bias probes, and repeated scoring stability. Use when building or changing a model-based evaluator.Votes: 0GitHub stars: 304
- Experiment BriefAuto-generate a structured experiment brief when a user expresses intent to test something. Use this skill whenever users mention testing, experiments, A/B tests, or want to validate a product change with data. Trigger on phrases like "I want to test...", "Let's experiment with...", "Should we A/B test...", "Can we test whether...", "I think X will improve Y", "We should validate...", "Let's try...", or any request involving running an experiment or measuring the impact of a change. This skil...Votes: 0GitHub stars: 304
- ExperimentThe analysis and lifecycle owner for experiments. Full experiment lifecycle: design, power analysis, statistical analysis, interpretation, reporting, and monitoring of A/B tests. Invoke as /experiment. Trigger on "A/B test", "experiment", "treatment vs control", "sample size", "MDE", "statistical significance", "ship decision", "test readout", "is this result significant?". Runs the SRM gate first.Votes: 0GitHub stars: 304
- Google Doc ExportCreate properly formatted Google Docs via the MCP API. This skill prevents common issues like text/image overlap, broken heading hierarchy, excessive whitespace, and inconsistent formatting. Use this skill automatically whenever you're building a Google Doc, calling any Google Docs MCP tool on the google-workspace server (create_doc, insert_doc_elements, insert_doc_image, batch_update_doc) or the google-docs server (upload_file_to_drive, write_formatted_content), designing a document structur...Votes: 0GitHub stars: 304
- Google Slides ExportCreate properly formatted Google Slides presentations via the MCP API. Use this skill whenever you're building Google Slides decks, calling batch_update_presentation, designing slide layouts, or the google-slides-creator or google-slides-reviewer agents are running. This skill prevents common API errors (zero-weight outlines, short object IDs, oversized batches, text overflow) and ensures professional deck design with consistent brand styling, proper spacing, and no overlapping elements. Appl...Votes: 0GitHub stars: 304