rails-query

97 / 100 · Low risk

Fine to try.

By MadBomber/experiments (GitHub) · data · 11 stars · scanned at commit 8139ff6

Answer any question that requires live data from a Rails 8.2+ app using `rails query`: counts, lookups, "how many X", ad-hoc investigation, schema exploration, EXPLAIN plans, and aggregates — whether locally or against a deployed environment via Kamal. Trigger broadly whenever the user asks for data from a Rails app's database, mentions `rails query` / `bin/rails query` / `bin/kamal query`, asks to inspect schema, tables, or models, wants to run SQL or ActiveRecord against the database, needs a…

Works with any agent that supports SKILL.md skills.

What this skill can do

Runs commands on your computer

This is disclosed by the author in the skill's SKILL.md or README.

Found in 11 places.

ai_misc/skills/rails-query/SKILL.md, line 44bin/rails query schema # every table
ai_misc/skills/rails-query/SKILL.md, line 56bin/rails query explain 'User.where(active: true).order(:created_at).limit(100)'
ai_misc/skills/rails-query/SKILL.md, line 65bin/rails query 'User.count'

Show 8 more

ai_misc/skills/rails-query/SKILL.md, line 74bin/rails query 'User.count' | jq '.rows[0][0]' # single scalar
ai_misc/skills/rails-query/SKILL.md, line 82bin/rails query [OPTIONS] '<expression>'
ai_misc/skills/rails-query/SKILL.md, line 111bin/rails query --sql 'SELECT id, email FROM users ORDER BY id' --page 2
ai_misc/skills/rails-query/SKILL.md, line 131bin/kamal query -d production 'User.count' 2>/dev/null
ai_misc/skills/rails-query/SKILL.md, line 139When your expression contains shell metacharacters — especially `(`, `)`, `*`, `;`, `&`, `|`, `<`, `>` — the remote shell eats a single layer of quoting. The ar
ai_misc/skills/rails-query/SKILL.md, line 145bin/kamal query -d production --sql '"SELECT COUNT(*) FROM users"'
ai_misc/skills/rails-query/SKILL.md, line 155bin/kamal query -d production '"User.where(email: \"alice@example.com\").pick(:id)"'
ai_misc/skills/rails-query/SKILL.md, line 164bin/rails query 'User.where(active: true).count'

Install

Paste this into your terminal. It downloads exactly the version we scanned, not whatever is newest.

if [ -e ~/.agents/skills/'rails-query' ] || [ -L ~/.agents/skills/'rails-query' ]; then echo 'A skill folder named rails-query already exists — not replacing it' >&2; false; else d=$(mktemp -d) && git clone --quiet --filter=blob:none --no-checkout 'https://github.com/MadBomber/experiments' "$d" && git -C "$d" checkout --quiet '8139ff68e8895b544661aa2ba8b53268d68652bc' -- 'ai_misc/skills/rails-query' && mkdir -p ~/.agents/skills && cp -R "$d"/'ai_misc/skills/rails-query' ~/.agents/skills/'rails-query' && rm -rf "$d"; fi

Codex reads ~/.agents/skills directly. For Claude Code, Cursor, Copilot, Gemini CLI, Antigravity or OpenCode, also link it. For Claude Code: ln -s ~/.agents/skills/'rails-query' ~/.claude/skills/'rails-query' (other agents: ~/.cursor/skills, ~/.copilot/skills, ~/.gemini/skills, ~/.gemini/config/skills, ~/.config/opencode/skills). Or install through the finder skill, which does both.

Badge for your README

The badge for MadBomber/experiments shows the score of its lowest-scoring skill.

SkillTrust badge for MadBomber/experiments

[![SkillTrust](https://zalavijaysinh.github.io/skilltrust/badges/MadBomber/experiments.svg)](https://zalavijaysinh.github.io/skilltrust/repos/MadBomber/experiments/)

Score history

Date	Version	Score
2026-11-10	`8139ff6`	97