Why Prisma? Connecting Node.js to PostgreSQL

You've written raw SQL by hand. Now let's connect a real Node.js application to a real PostgreSQL database, and see how Prisma makes that connection type-safe and far less error-prone.

The stack

Node.js application
        │
        ▼
  Prisma Client   (generated, type-safe query API)
        │
        ▼
  PostgreSQL database

Prisma is an ORM (Object-Relational Mapper) for Node.js and TypeScript. You describe your data once, in a schema file, and Prisma generates:

• Prisma Client, a fully-typed query API your app calls instead of writing SQL strings by hand.
• Migrations, versioned SQL files that evolve your database schema safely over time.

Why not just write SQL directly?

You still can, Prisma Client executes real SQL under the hood. What it adds is:

• Type safety, your editor autocompletes column names and catches typos before you ever run the code.
• Migrations tracked in version control, so your team and your database never drift out of sync.
• Protection against SQL injection by default, since every query is parameterized.