New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Metabase Prod Query

by haacked in haacked/dotfiles

Query PostHog production Metabase. An agent skill from haacked/dotfiles.

No licenceAuto-check: notesDevelopment

Install Metabase Prod Query

skills CLI
$ npx skills add haacked/dotfiles --skill metabase-prod-query -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install haacked/dotfiles metabase-prod-query --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/haacked/dotfiles.git skills-src && mkdir -p .claude/skills && cp -r skills-src/ai/skills/metabase-prod-query .claude/skills/metabase-prod-query && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
metabase-prod-query
GitHub stars
134
Token cost
~1.5k tokens
SKILL.md length
696 words
Files
1
Skills in repo
29
Repo updated
First seen
Licence
None found

At a glance

Query PostHog production Metabase. An agent skill from haacked/dotfiles.

  • Works in 8 steps: Confirm scope → Verify session → Refresh database IDs → …
  • The user wants prod data such as counts
  • SKILL.md covers Non-negotiables, Steps, Error handling and Notes
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Metabase Prod Query is an agent skill from haacked/dotfiles. Query PostHog production Metabase. Use when the user wants prod data such as counts, distributions, customer-report debugging, or region comparisons. Not for local dev investigations; use the posthog-db MCP for those.

Its SKILL.md is about 1.5k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Development. It works with PostHog, Model Context Protocol and SQL. The repository describes itself as: My dotfiles and scripts I use on dev machines.

When your agent uses it

  • The user wants prod data such as counts
  • Customer-report debugging
  • Region comparisons

Example prompts

  • “/metabase-prod-query”

Requirements

  • Pre-approved tools (allowed-tools): Bash, Read, Write, Edit, Grep, Glob

Workflow steps

8 steps, taken from the step headings in SKILL.md.

  1. Confirm scope
  2. Verify session
  3. Refresh database IDs
  4. Compose SQL
  5. Show SQL and get approval
  6. Run the query
  7. Read and summarize results
  8. Clean up (optional)

What it can do on your machine

Read from SKILL.md and the folder at commit d3508b6. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves these tools, so the agent can use them without asking each time:

    • Bash
    • Read
    • Write
    • Edit
    • Grep
    • Glob

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are bash).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Metabase Prod Query loads about 1.5k tokens when it runs. Until then it costs about 60 tokens; SKILL.md has 696 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~60
When it runs · the whole SKILL.md, loaded when a task matches
~1.5k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check: notes

The automated check noted patterns worth knowing about, such as sudo or a known installer.

  • NotePre-approves every shell command (allowed-tools: Bash)SKILL.md
    allowed-tools: Bash, Read, Write, Edit, Grep, Glob

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Without a licence we can't republish the file, so here is its outline and opening line. It has 696 words (~1,513 tokens).

“Run SQL against PostHog production Metabase via hogli metabase:*. Production Metabase sits behind ALB Cognito OAuth, so this is the only path that works (API keys won't pass the ALB).”

— opening of SKILL.md by haacked
name
metabase-prod-query
allowed-tools
Bash, Read, Write, Edit, Grep, Glob
argument-hint
[--region us|eu|both] [<question or SQL>]
model
sonnet
metadata.execution-tier
balanced

Read the full SKILL.md on GitHub

Files

Just SKILL.md in ai/skills/metabase-prod-query of haacked/dotfiles.

Open the folder on GitHubat commit d3508b6

Compare with similar skills

Metabase Prod Query next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Metabase Prod Query compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Metabase Prod Query this skillhaacked/dotfiles134—~1.5kAutomated safety check: NotesNone
Exploring MCP SessionsPostHog/posthog40k—~2.1kAutomated safety check: PassCustom licence
Exploring MCP Tool QualityPostHog/posthog40k—~2kAutomated safety check: PassCustom licence
Triaging Warehouse Sync TicketsPostHog/posthog40k—~6.3kAutomated safety check: WarnCustom licence
PR Bot Reviewspgplex/pgconsole155—~2.1kAutomated safety check: PassApache-2.0
Refactortermide/termide172—~2.8kAutomated safety check: PassMIT

Similar skills

  • Exploring MCP Sessions

    PostHog/posthog

    Official

    Investigate individual PostHog MCP sessions — the sequence of tool calls a single agent made in one run, what it was trying to do, and where it went wrong.

    40k GitHub stars~2.1k tokensUpdated today
    Agent WorkflowsAuto-check passed

  • Exploring MCP Tool Quality

    PostHog/posthog

    Official

    Investigate the quality of PostHog MCP tool calls — error rates, latency, reach, and which tools are failing or slow.

    40k GitHub stars~2k tokensUpdated today
    Agent WorkflowsAuto-check passed

  • Triaging Warehouse Sync Tickets

    PostHog/posthog

    Official

    Debug a customer's data warehouse source, schema, or table from a support ticket, using PostHog's own production data.

    40k GitHub stars~6.3k tokensUpdated today
    DatabasesAuto-check: warnings

  • PR Bot Reviews

    pgplex/pgconsole

    Triage, verdict, and reply to automated PR review comments from GitHub Copilot and Greptile, then iterate until the bots have nothing left to say.

    155 GitHub stars~2.1k tokensUpdated 1 mo ago
    DevelopmentAuto-check passed

  • Refactor

    termide/termide

    Full-workspace code quality analysis and refactoring with validation

    172 GitHub stars~2.8k tokensUpdated today
    DevelopmentAuto-check passed

  • Release Management

    termide/termide

    Prepare and publish a project release with version updates, changelog generation, tagging, and validation

    172 GitHub stars~6.8k tokensUpdated today
    DevelopmentAuto-check passed

More from haacked/dotfiles

All 29 skills in this repo

  • Support

    haacked/dotfiles

    Support hero workflow — start a ticket investigation with auto-organized notes, find existing notes, or generate the weekly highlights log.

    134 GitHub stars~2.9k tokensUpdated today
    Auto-check passed

  • Analyze Permissions

    haacked/dotfiles

    Analyze accumulated permissions and suggest smart wildcard patterns.

    134 GitHub stars~1.2k tokensUpdated today
    Auto-check passed

  • Followup

    haacked/dotfiles

    Capture a follow-up item mid-session in seconds, list open items, close one, or run a review pass.

    134 GitHub stars~1.1k tokensUpdated today
    Auto-check passed

  • Handoff

    haacked/dotfiles

    Write or resume a handoff document so the next agent session can pick up the current work.

    134 GitHub stars~2.1k tokensUpdated today
    Auto-check passed

  • Note

    haacked/dotfiles

    Capture complex technical discoveries into structured, reusable notes.

    134 GitHub stars~1.1k tokensUpdated today
    Auto-check passed

  • Quarterly Planning

    haacked/dotfiles

    Draft quarterly goals for a PostHog team (defaults to Feature Flags), clustering open issues into themes and producing goals in PostHog's HOGS format.

    134 GitHub stars~3.1k tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Metabase Prod Query

What does Metabase Prod Query do?

Query PostHog production Metabase. An agent skill from haacked/dotfiles. Metabase Prod Query is an agent skill from haacked/dotfiles. Query PostHog production Metabase.

When should I use Metabase Prod Query?

Metabase Prod Query fits situations like: the user wants prod data such as counts; customer-report debugging; region comparisons.

How do I install Metabase Prod Query in Claude Code?

Run `npx skills add haacked/dotfiles --skill metabase-prod-query -a claude-code`. Or copy the skill folder (ai/skills/metabase-prod-query in haacked/dotfiles) into .claude/skills/metabase-prod-query in your project. Claude Code loads it when a task matches its description.

How do I install Metabase Prod Query in Codex?

Run `npx skills add haacked/dotfiles --skill metabase-prod-query -a codex`. Or copy the skill folder (ai/skills/metabase-prod-query in haacked/dotfiles) into .agents/skills/metabase-prod-query in your project. Codex loads it when a task matches its description.

Can I use Metabase Prod Query in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add haacked/dotfiles --skill metabase-prod-query -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/metabase-prod-query, .gemini/skills/metabase-prod-query, .github/skills/metabase-prod-query and .opencode/skills/metabase-prod-query in your project.

What does Metabase Prod Query need to run?

SKILL.md names no scripts, command-line tools or credentials: Metabase Prod Query is instructions for the agent only. Its frontmatter pre-approves these tools: Bash, Read, Write, Edit, Grep, Glob.

Does Metabase Prod Query access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Metabase Prod Query safe to install?

Our automated static check of SKILL.md found notes only (pre-approves every shell command (allowed-tools: bash)), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does Metabase Prod Query use?

No licence was found for Metabase Prod Query or its repository. Without one, default copyright applies: ask the author before reusing or redistributing it.

How many tokens does Metabase Prod Query use?

About 1.5k tokens (SKILL.md is roughly 6.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Metabase Prod Query?

Skills that share tags, products or a category with Metabase Prod Query: Exploring MCP Sessions (PostHog/posthog, 40k stars), Exploring MCP Tool Quality (PostHog/posthog, 40k stars), Triaging Warehouse Sync Tickets (PostHog/posthog, 40k stars) and PR Bot Reviews (pgplex/pgconsole, 155 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Metabase Prod Query?

haacked (a GitHub user) maintains it in haacked/dotfiles, which has 134 GitHub stars. The repository holds 29 skills in this directory. The repository was last updated on October 9, 2026.

Source: haacked/dotfiles on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.