More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Drizzle ORM: SQL You Can Type-Check

    1

    Type-safe Postgres access with Drizzle ORM — schema, migrations, relations, and queries that read like SQL and check like TypeScript.

    $5

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Drizzle ORM: SQL You Can Type-Check

    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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 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

    Listed3 days ago

    What's inside

    Frequently Asked Questions

    Yes — and that is the point. Drizzle queries read like SQL, so knowing SQL makes you faster and keeps you from writing a bad query with perfect types. The skill keeps you close to the SQL, not away from it.

    Always. Generated SQL can drop columns, truncate data on type changes, or add a not-null column with no default for existing rows. Reading it is the review; applying it unread is not.

    When the project has no TypeScript, when the store is schema-less, or when the team needs an ORM that manages the database for them. Drizzle is for teams that want to stay close to SQL with types on top.