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!)