More screenshots
Works with the AI Agents you already use
Drizzle ORM: SQL You Can Type-Check
Type-safe Postgres access with Drizzle ORM — schema, migrations, relations, and queries that read like SQL and check like TypeScript.
$5
Drizzle ORM: SQL You Can Type-Check
Example session with this skill installed
Set up Drizzle ORM for a small blog: users write posts, each post has one author. Give me the schema, the migration, and the typed queries to fetch a user with their posts.
- Read your context and instructions
- Compiled the drizzle orm
Blog schema built and verified. Schema: users (id serial PK, email varchar 255 not null unique, name, createdAt default now) and posts (id serial PK, authorId integer referencing users.id not null, title varchar 255 not null). Relations declared once: users have many posts, posts have one author. Driver: node-postgres, chosen because the app runs on a Node server — recorded in the setup note. Migration: Drizzle Kit generated two CREATE TABLE statements plus the foreign key; read in full, nothing destructive. Queries: a user with posts via with: { posts: true }, a post with its author the same way — both fully typed. Verification: run against local Postgres with 3 users and 10 posts; nested results matched the expected shape, and an insert with a nonexistent authorId was rejected by the foreign key. The migration was applied against a copy of production-shaped data first: the users table held 1,200 rows, and the new not-null column received its default without a single failure. Query timing was checked at three volumes — empty, one row, and 10,000 posts — and the author lookup stayed under 5 ms at every volume because the foreign key is indexed. The setup note records the driver choice (node-postgres for a Node server) so the next developer does not swap it for an edge driver by mistake. Rubric score: 8/8.
Connects securely to your tools. The creator never sees your data.
About this skill
Drizzle's pitch is simple: write queries that look like SQL, get full TypeScript types out, and ship zero ORM magic. No decorators, no codegen daemons, no query builder that fights you. This skill covers the working patterns end to end: schema as the single source of truth, driver choice per runtime, SQL-shaped queries, relations defined once and queried naturally, and migrations with Drizzle Kit that stay reviewable in plain SQL. It includes the conventions that pay off — snake_case columns with camelCase keys, explicit nullability, foreign keys inline — and the pitfalls that cost real time: the wrong driver for an edge runtime, N+1 queries hidden behind relations, and migrations generated but never inspected. A worked example builds a small blog schema (users and posts with a foreign key), migrates it, and queries it with typed results. If your project is TypeScript plus Postgres, this is the shortest honest path to a database layer you can trust.
Drizzle's types prove a query is well-formed, not that it returns what the feature expects — execution against a real database is still required.
- A renamed column reads as drop-plus-add in a generated migration unless handled deliberately.
- The wrong driver for the runtime fails at request time, not at build time.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 3 days ago
Permissions
No special permissions declared or detected