Validate and auto-generate TypeScript types from raw SQL queries in PostgreSQL.
SafeQL - Automatic Type Inference & Validation for PostgreSQL Queries • Get started
SafeQL automatically infers the type of the query result based on the query itself.
SafeQL works with any PostgreSQL client, including Prisma, Sequelize, pg, Postgres.js, and more.
SafeQL was built in mind to be easy to use and integrate with your existing codebase.
SafeQL was built with monorepos and microservices in mind, and it's easy to use with multiple databases.
I would first recommend follow the instructions in the documentation.
npm install --save-dev @ts-safeql/eslint-plugin libpg-query
Since libpg-query doesn't seem to support Windows, the only way to make SafeQL work on Windows is by using WSL2 (see issue).