HN Showcase
Back to browse
GitHub Repository

Kinetic SQL is a next-gen Node.js client that wraps PostgreSQL, MySQL & SQLite with features that enable the developer to interact with databases seamlessly.

8 starsTypeScript

Kinetic SQL – A lightweight, real-time SQL Engine for Node.js

by im_kapilkumar·Feb 25, 2026·2 points·0 comments
Visit ProjectView on HN

AI Analysis

●MidShip It

ORM alternative with real-time CDC, but Prisma, Drizzle, and Supabase Realtime already own this space.

Strengths
  • •Connection pooling + automatic type generation from schema is genuinely useful for Node.js daily work
  • •Real-time subscriptions for INSERT/UPDATE/DELETE nativelysolve a real UX pain (live dashboards)
  • •NestJS module provides zero-config integration, reducing boilerplate
Weaknesses
  • •Directly competes with mature, well-funded tools (Prisma, Drizzle, Supabase) in a solved category
  • •No production case studies, benchmarks, or evidence it outperforms established ORMs on speed or DX
Target Audience

Node.js backend developers building Express/Fastify/NestJS apps, particularly those wanting real-time DB events

Similar To

Prisma · Drizzle ORM · Supabase Realtime

Post Description

Hi HN, I'm the author.

I've spent years building Node.js backends (mostly Express and NestJS) and I’ve consistently found traditional ORMs like TypeORM too heavy, while Prisma’s subscription models didn't quite fit my need for lightweight CDC (Change Data Capture). I wanted something universal that felt closer to the metal but still handled real-time events seamlessly.

Over the past couple of days, I built Kinetic SQL. It's a thin, highly flexible SQL wrapper for Node.js (supporting Postgres, MySQL, and SQLite).

The CORE focus: Framework Agnostic: Works beautifully with Express, Fastify, or Vanilla Node, with a dedicated seamless-integration module for NestJS included as a bonus.

Real-time Subscriptions: Listen to table changes (INSERT/UPDATE/DELETE) natively and push to clients (perfect for live dashboards).

Zero-Touch Interfaces: The CLI (npx k-sql gen) reads your schema and auto-generates absolute type safety. No more writing interfaces by hand.

Native DB Functions: Call your database procedures directly as native JavaScript methods.

To stress-test the real-time engine, I built a high-frequency stock market simulator (running on a free Vercel/Render stack with a 0-second cold start):

Live Demo: https://live-stock-simulator.vercel.app/ NPM: https://www.npmjs.com/package/kinetic-sql

I'd love to hear your thoughts on the API design. (P.S. MSSQL support is coming soon!)

Similar Projects