Skip to main content
skill CX Codex

sqlmodel-expert — Claude Code skill: what it does, how to install

sqlmodel-expert is a Claude Code skill that guides SQLModel schema design and Alembic migrations. It helps configure table relationships and resolve N+1 query latency issues.

no license 159 installs ★ 1 updated 2026-01-27

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add bilalmk/todo_correct --skill sqlmodel-expert -a claude-code
Open on GitHub

What sqlmodel-expert does

The skill guides the assistant through SQLModel architecture patterns. It covers relational definitions, table inheritance, and timestamp mixins. Many-to-many links require intermediate association models. The guides provide explicit patterns for them.

Query optimization is another focal area. The instructions fix N+1 query bottlenecks by applying eager loading via selectinload. The project also supplies utility scripts: scripts/migrate.sh for Alembic tasks and scripts/init_db.py for database bootstrapping.

Testing the generated migrations requires an active database connection and installed Alembic packages.

What it helps with

  • define many-to-many table relationships with link models
  • eliminate N+1 query bottlenecks using selectinload
  • autogenerate and apply Alembic schema revisions
  • configure composite keys and database indexes

Example prompts for the agent

  • Set up a one-to-many relationship between Author and Book models in SQLModel
  • Fix N+1 query latency in this endpoint by adding eager loading with selectinload
  • Generate an Alembic migration script to add a unique constraint on user slugs

How to install sqlmodel-expert

1Skills CLI (Vercel)

npx skills add bilalmk/todo_correct --skill sqlmodel-expert -a claude-code

2Manually: put the files in place

~/.claude/skills/sqlmodel-expert/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/sqlmodel-expert/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about sqlmodel-expert

How do I install sqlmodel-expert in Claude Code?

Run npx skills add bilalmk/todo_correct --skill sqlmodel-expert -a claude-code. The file will be placed in ~/.claude/skills/sqlmodel-expert/SKILL.md.

What does sqlmodel-expert do?

It provides architecture patterns for SQLModel ORM models, query eager loading strategies, and Alembic database migration workflows.

Does this skill include migration management scripts?

Yes, it references helper utilities including scripts/init_db.py for database setup and scripts/migrate.sh for common Alembic tasks.

Similar skills

All skills for Backend and APIs →

From the same set3

Project sponsors

Companies that keep this analytics open