SQL Lint
Static lint for sqlc-style SQL catalogs. Catches duplicate query names, missing semicolons, SELECT *, double-wildcard LIKE, and other cheap-but-easy-to-miss mistakes. Optional sqlfluff integration for full style coverage.
Install
npx skills add mizchi/skills --skill sql-lintgit clone --depth 1 https://github.com/mizchi/skills.git /tmp/skills
mkdir -p ~/.claude/skills
cp -r /tmp/skills/sql-lint ~/.claude/skills/sql-lintPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# SQL Lint Use this when a project has a SQL catalog (`-- name: X :type` comments or any named-query convention) and wants to enforce basic hygiene without adopting a heavy SQL linter. ## Two layers This skill ships **two** linters, with different cost / coverage trade-offs. ### Layer 1: catalog-lint (built-in, zero deps) `scripts/catalog-lint.mjs` is a Node 24+ script with no dependencies. It catches: - **duplicate-name**: two queries with the same `-- name: X` header. Some codegens silently shadow; others break. - **missing-semicolon**: queries that omit the trailing `;`. sqlc rejects these at build time, but catalog-lint surfaces them in fmt-time. - **empty-body**: header with no SQL body. - **malformed-name**: `-- name:` line that doesn't match `name: X :type`. - **select-star**: `SELECT *` (always over-fetch). - **double-wildcard-like**: `LIKE '%...%'` (full-table scan risk). Run (this is the default first pass — start here before reaching for sqlfluff): ```bash # `scripts/` is relative to THIS skill's directory. From elsewhere, use the # absolute path, e.g. node "$CLAUDE_SKILLS_DIR/sql-lint/scripts/catalog-lint.mjs". node scripts/catalog-lint.mjs your-project/db/queries.sql echo "exit=$?" # 0 = clean, 1 = findings — the exit code IS the pass/fail signal ```
Details
- Skill name
sql-lint- Repository
- mizchi/skills
- Path
sql-lint/SKILL.md- Repo updated
- 18 November 2026
FAQ
What does the SQL Lint skill do?
Static lint for sqlc-style SQL catalogs. Catches duplicate query names, missing semicolons, SELECT *, double-wildcard LIKE, and other cheap-but-easy-to-miss mistakes. Optional sqlfluff integration for full style coverage.
How do I install the SQL Lint skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add mizchi/skills --skill sql-lint. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is SQL Lint popular?
It lives in mizchi/skills, which has 423 GitHub stars and 6 forks.
Related skills
Actions CI Tuning
423mizchi/skills
Use when auditing or improving GitHub Actions workflows for a project. Covers cache setup (npm/pnpm/yarn), job parallelism, shard-based test splitting, artifact handling pitfalls, and Playwright-specific patterns. Trigger on: slow CI, cache miss, flaky shard jobs, merge-reports failures, or an explicit 'tune CI' request.
AI Index
423mizchi/skills
Method and tooling for measuring how AI-generated a piece of prose reads, in Japanese or English. Two layers — a deterministic lint for removable surface tells (scripts/slopscore.py, no API) and a judgment layer of typed probabilistic questions (Jev noul/score) for the tells that survive editing. Includes measured human/AI baselines, a gap-first calibration procedure, and labeled fixtures. Use when building or calibrating an AI-likeness score, or when a draft needs a defensible number rather than a vibe. For writing guidance use natural-writing-ja / natural-writing-en instead.
Apm Usage
423mizchi/skills
Reference for APM manifests, installation, targeted updates, deployment paths and lockfiles. Invoke when the user explicitly asks about APM or apm.yml, or an unfamiliar APM command/error needs exact CLI details. Do not automatically invoke for every project that happens to have installed skills.
SQL Plan Audit
423mizchi/skills
Run EXPLAIN QUERY PLAN against every query in a sqlc-style catalog and diff the plans against a baseline. Detects new full-table SCANs and TEMP B-TREE sort scans introduced by PRs. SQLite/D1-only today; engine extension noted below.
Node Sqlite Vec
423mizchi/skills
Use when setting up Node 24+ built-in `node:sqlite` with the loadable `sqlite-vec` extension for vector / RAG storage in TypeScript without `better-sqlite3`, or when debugging vec0 BigInt rowids, vitest hanging on sqlite-vec, `.ts` import errors under `node:sqlite`, or "sqlite extension not loadable". Covers extension loading, version-specific test-runner resolution issues, tsconfig flags, and CLI shebang. Trigger on `node:sqlite`, `sqlite-vec`, vec0 / vector storage even when the user does not name better-sqlite3.
SQL Schema Audit
423mizchi/skills
Index coverage and N+1 review aids for SQLite/D1 schemas with a sqlc catalog. Surfaces unused indexes (with FK CASCADE awareness so cascade-load-bearing indexes are not flagged), queries that scan tables without index help, and `for`-loops calling generated SQL fns.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.