Postgres
sanjay3290/ai-skills
Execute read-only SQL queries against multiple PostgreSQL databases.
Guide to Metabase for open-source research data analytics and dashboards
$ npx skills add wentorai/research-plugins --skill metabase-analytics-guide -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install wentorai/research-plugins metabase-analytics-guide --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/wentorai/research-plugins.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/analysis/dataviz/metabase-analytics-guide .claude/skills/metabase-analytics-guide && rm -rf skills-srcUse ~/.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/
Install the "metabase-analytics-guide" agent skill from https://github.com/wentorai/research-plugins/tree/main/skills/analysis/dataviz/metabase-analytics-guide into .claude/skills/metabase-analytics-guide/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "metabase-analytics-guide", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/wentorai/research-plugins/tree/main/skills/analysis/dataviz/metabase-analytics-guideType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add wentorai/research-plugins --skill metabase-analytics-guide -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install wentorai/research-plugins metabase-analytics-guide --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/wentorai/research-plugins.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/analysis/dataviz/metabase-analytics-guide .agents/skills/metabase-analytics-guide && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "metabase-analytics-guide" agent skill from https://github.com/wentorai/research-plugins/tree/main/skills/analysis/dataviz/metabase-analytics-guide into .agents/skills/metabase-analytics-guide/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "metabase-analytics-guide", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add wentorai/research-plugins --skill metabase-analytics-guide -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install wentorai/research-plugins metabase-analytics-guide --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/wentorai/research-plugins.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/analysis/dataviz/metabase-analytics-guide .cursor/skills/metabase-analytics-guide && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "metabase-analytics-guide" agent skill from https://github.com/wentorai/research-plugins/tree/main/skills/analysis/dataviz/metabase-analytics-guide into .cursor/skills/metabase-analytics-guide/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "metabase-analytics-guide", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/wentorai/research-plugins.git --path skills/analysis/dataviz/metabase-analytics-guide--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add wentorai/research-plugins --skill metabase-analytics-guide -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install wentorai/research-plugins metabase-analytics-guide --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/wentorai/research-plugins.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/analysis/dataviz/metabase-analytics-guide .gemini/skills/metabase-analytics-guide && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "metabase-analytics-guide" agent skill from https://github.com/wentorai/research-plugins/tree/main/skills/analysis/dataviz/metabase-analytics-guide into .gemini/skills/metabase-analytics-guide/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "metabase-analytics-guide", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install wentorai/research-plugins metabase-analytics-guideInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add wentorai/research-plugins --skill metabase-analytics-guide -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/wentorai/research-plugins.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/analysis/dataviz/metabase-analytics-guide .github/skills/metabase-analytics-guide && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "metabase-analytics-guide" agent skill from https://github.com/wentorai/research-plugins/tree/main/skills/analysis/dataviz/metabase-analytics-guide into .github/skills/metabase-analytics-guide/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "metabase-analytics-guide", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add wentorai/research-plugins --skill metabase-analytics-guide -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install wentorai/research-plugins metabase-analytics-guide --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/wentorai/research-plugins.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/analysis/dataviz/metabase-analytics-guide .opencode/skills/metabase-analytics-guide && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "metabase-analytics-guide" agent skill from https://github.com/wentorai/research-plugins/tree/main/skills/analysis/dataviz/metabase-analytics-guide into .opencode/skills/metabase-analytics-guide/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "metabase-analytics-guide", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
metabase-analytics-guideGuide to Metabase for open-source research data analytics and dashboards
Metabase Analytics Guide is an agent skill from wentorai/research-plugins. Guide to Metabase for open-source research data analytics and dashboards
Its SKILL.md is about 2.1k 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 Databases, covering Data analysis and Data visualization. It works with SQL and PostgreSQL. The repository describes itself as: 350+ academic research skills, MCP configs, and plugins for Research-Claw and AI agents. The licence is MIT.
4 steps, taken from the first numbered list in SKILL.md.
Read from SKILL.md and the folder at commit bf44b3c. It shows what the files ask for, not the result of running them.
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Shell commands in SKILL.md call:
dockerFrom the folder's file list and the shell code blocks in SKILL.md.
Links to these hosts (documentation or services it may open):
metabase.comgithub.comFrom URLs in SKILL.md, links to its own repository left out.
Names these keys or tokens, usually read from environment variables:
POSTGRES_PASSWORDMETABASE_EMBEDDING_SECRETFrom names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Metabase Analytics Guide loads about 2.1k tokens when it runs. Until then it costs about 24 tokens; SKILL.md has 527 words of instructions outside code blocks.
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.
The automated check found no risky patterns in SKILL.md.
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.
The full file from wentorai/research-plugins at commit bf44b3c, republished under its MIT licence (© wentorai). 527 words, ~2,093 tokens.
.claude/skills/metabase-analytics-guide/SKILL.md (or your agent's skills folder).Metabase is a powerful open-source business intelligence and analytics tool with over 46K stars on GitHub. It allows researchers and data analysts to explore data, create visualizations, and build dashboards without writing SQL, though it fully supports custom SQL queries for advanced users. Metabase connects to a wide variety of databases and provides a browser-based interface that makes data exploration accessible to team members regardless of their technical background.
For academic research groups and labs, Metabase serves as an excellent self-hosted platform for tracking experimental data, monitoring research progress, and creating shared dashboards for collaborative projects. Its ability to connect directly to PostgreSQL, MySQL, SQLite, and many other databases means it can be pointed at existing research data stores without data migration. Researchers can set up automated reports, scheduled email digests, and shared dashboards that keep the entire team informed.
Metabase's no-code query builder is particularly valuable in interdisciplinary research teams where not all members are comfortable with SQL. Principal investigators, graduate students, and collaborators can all explore the same datasets through an intuitive visual interface while power users retain full SQL access for complex analyses.
# Quick start with Docker
docker run -d -p 3000:3000 \
--name metabase \
-v metabase-data:/metabase-data \
-e MB_DB_TYPE=postgres \
-e MB_DB_DBNAME=metabase_app \
-e MB_DB_PORT=5432 \
-e MB_DB_USER=$METABASE_DB_USER \
-e MB_DB_PASS=$METABASE_DB_PASS \
-e MB_DB_HOST=db-host \
metabase/metabase
# Access at http://localhost:3000version: "3.9"
services:
metabase:
image: metabase/metabase:latest
container_name: research-metabase
ports:
- "3000:3000"
environment:
MB_DB_TYPE: postgres
MB_DB_DBNAME: metabase_app
MB_DB_PORT: 5432
MB_DB_USER: ${METABASE_DB_USER}
MB_DB_PASS: ${METABASE_DB_PASS}
MB_DB_HOST: postgres
MB_SITE_NAME: "Research Lab Analytics"
depends_on:
- postgres
volumes:
- metabase-data:/metabase-data
postgres:
image: postgres:16
environment:
POSTGRES_DB: metabase_app
POSTGRES_USER: ${POSTGRES_USER}
POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
volumes:
- pg-data:/var/lib/postgresql/data
volumes:
metabase-data:
pg-data:Metabase supports connecting to many database types commonly used in research environments.
Navigate to Admin > Databases > Add Database in the Metabase UI. For a typical research PostgreSQL database:
Display name: Lab Experiment Database
Host: research-db.lab.university.edu
Port: 5432
Database name: experiments
Username: (use environment variable $DB_USER)
Password: (use environment variable $DB_PASS)Enable "Auto-run queries" and set "Scan frequency" to daily for research databases that update regularly.
A common research use case is tracking experiment progress and results. Here is an example SQL query for monitoring experiment completion rates:
-- Experiment completion overview
SELECT
e.project_name,
COUNT(*) AS total_experiments,
COUNT(CASE WHEN e.status = 'completed' THEN 1 END) AS completed,
COUNT(CASE WHEN e.status = 'in_progress' THEN 1 END) AS in_progress,
COUNT(CASE WHEN e.status = 'failed' THEN 1 END) AS failed,
ROUND(
COUNT(CASE WHEN e.status = 'completed' THEN 1 END)::NUMERIC /
NULLIF(COUNT(*), 0) * 100, 1
) AS completion_rate
FROM experiments e
WHERE e.created_at >= CURRENT_DATE - INTERVAL '90 days'
GROUP BY e.project_name
ORDER BY completion_rate DESC;-- Sample processing metrics
SELECT
DATE_TRUNC('week', s.processed_at) AS week,
s.sample_type,
COUNT(*) AS samples_processed,
AVG(s.quality_score) AS avg_quality,
PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY s.processing_time)
AS median_processing_hours
FROM samples s
WHERE s.processed_at >= CURRENT_DATE - INTERVAL '6 months'
GROUP BY DATE_TRUNC('week', s.processed_at), s.sample_type
ORDER BY week DESC, sample_type;-- Track manuscript progress across the lab
SELECT
p.title,
p.lead_author,
p.status,
p.target_journal,
p.submission_date,
CASE
WHEN p.status = 'draft' THEN 1
WHEN p.status = 'internal_review' THEN 2
WHEN p.status = 'submitted' THEN 3
WHEN p.status = 'revision' THEN 4
WHEN p.status = 'accepted' THEN 5
WHEN p.status = 'published' THEN 6
END AS stage_number,
CURRENT_DATE - p.last_updated AS days_since_update
FROM publications p
WHERE p.year >= EXTRACT(YEAR FROM CURRENT_DATE) - 1
ORDER BY stage_number, p.last_updated;Metabase supports scheduled reports and conditional alerts, which are useful for research operations.
Question: "Failed experiments in last 7 days"
Alert when: Results are above threshold (e.g., > 5 failures)
Check frequency: Daily
Notify: Lab manager email, Slack channelThis allows labs to automatically detect quality issues in experimental workflows.
Metabase supports embedding dashboards into other web applications via iframes or its embedding SDK.
<!-- Embed a dashboard in a lab portal -->
<iframe
src="http://metabase.lab.internal/public/dashboard/abc123-def456"
frameborder="0"
width="100%"
height="800"
allowtransparency
></iframe>For authenticated embedding, use signed JWTs to control access:
import jwt
import time
embedding_secret = os.environ["METABASE_EMBEDDING_SECRET"]
payload = {
"resource": {"dashboard": 42},
"params": {"project_id": 7},
"exp": int(time.time()) + 600 # 10-minute expiry
}
signed = jwt.encode(payload, embedding_secret, algorithm="HS256")
embed_url = f"http://metabase.lab.internal/embed/dashboard/{signed}"© wentorai, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Just SKILL.md in skills/analysis/dataviz/metabase-analytics-guide of wentorai/research-plugins.
Open the folder on GitHubat commit bf44b3c
We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders, from 1 other GitHub owner. This page covers the copy in wentorai/research-plugins, which our catalogue first saw on October 7, 2026.
Metabase Analytics Guide 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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Metabase Analytics Guide this skillwentorai/research-plugins | 298 | 1 repos | ~2.1k | Automated safety check: Pass | MIT | |
| Postgressanjay3290/ai-skills | 431 | 1 repos | ~975 | Automated safety check: Pass | Apache-2.0 | |
| Semantic Analystsidequery/sidemantic | 129 | — | ~982 | Automated safety check: Pass | AGPL-3.0 | |
| Analyzing Dataastronomer/agents | 451 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | |
| VisualizationFrankChen021/datastoria | 327 | — | ~1.2k | Automated safety check: Pass | Custom licence | |
| Tableau Dashboard CreatorKilo-Org/kilo-marketplace | 190 | — | ~3.8k | Automated safety check: Notes | MIT |
sanjay3290/ai-skills
Execute read-only SQL queries against multiple PostgreSQL databases.
sidequery/sidemantic
Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer.
astronomer/agents
Queries the data warehouse with SQL and answers business questions about data.
FrankChen021/datastoria
Rules for charts and visualization. An agent skill from FrankChen021/datastoria.
Kilo-Org/kilo-marketplace
Takes a plain-language dashboard request through brand setup, data exploration, planning, an interactive HTML mock and a Tableau implementation spec.
ancoleman/ai-design-components
Time-series database implementation for metrics, IoT, financial data, and observability backends.
wentorai/research-plugins
Craft structured research abstracts that maximize clarity and journal acceptance
wentorai/research-plugins
Manage academic citations across BibTeX, APA, MLA, and Chicago formats
wentorai/research-plugins
Summarize academic papers with structured extraction of key elements
wentorai/research-plugins
Evidence-based study techniques for academic learning and retention
wentorai/research-plugins
Adjust writing tone and register for academic audiences and venues
wentorai/research-plugins
Academic translation, post-editing, and Chinglish correction guide
Works with
Categories
Guide to Metabase for open-source research data analytics and dashboards. Metabase Analytics Guide is an agent skill from wentorai/research-plugins.
Metabase Analytics Guide fits situations like: tasks that involve Data analysis; tasks that involve Data visualization.
Run `npx skills add wentorai/research-plugins --skill metabase-analytics-guide -a claude-code`. Or copy the skill folder (skills/analysis/dataviz/metabase-analytics-guide in wentorai/research-plugins) into .claude/skills/metabase-analytics-guide in your project. Claude Code loads it when a task matches its description.
Run `npx skills add wentorai/research-plugins --skill metabase-analytics-guide -a codex`. Or copy the skill folder (skills/analysis/dataviz/metabase-analytics-guide in wentorai/research-plugins) into .agents/skills/metabase-analytics-guide in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add wentorai/research-plugins --skill metabase-analytics-guide -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-analytics-guide, .gemini/skills/metabase-analytics-guide, .github/skills/metabase-analytics-guide and .opencode/skills/metabase-analytics-guide in your project.
Going by SKILL.md and its folder, Metabase Analytics Guide needs the command-line tools its instructions call (docker) and credentials named POSTGRES_PASSWORD and METABASE_EMBEDDING_SECRET. Our summary lists: Python 3; Docker; A credential in METABASE_EMBEDDING_SECRET.
SKILL.md names 2 domains. As links in the text: metabase.com and github.com. This is read from the text; nothing was executed.
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
Metabase Analytics Guide is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 2.1k tokens (SKILL.md is roughly 8.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with Metabase Analytics Guide: Postgres (sanjay3290/ai-skills, 431 stars), Semantic Analyst (sidequery/sidemantic, 129 stars), Analyzing Data (astronomer/agents, 451 stars) and Visualization (FrankChen021/datastoria, 327 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
wentorai (a GitHub user) maintains it in wentorai/research-plugins, which has 298 GitHub stars. The repository holds 405 skills in this directory. The repository was last updated on June 19, 2026.
Source: wentorai/research-plugins on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.