Typesafe SQL for TypeScript.
What we like
Prevents mistakes by providing types for SQL queries. Understands fields types, joins, subqueries, aliases, and other advanced SQL features. Also supports dialects from databases like Planetscale, D1, AWS, etc. Enables autocomplete in your IDE. Migrations can also be written in TypeScript.
What we don't like
Only works with Postgres, MySQL & SQLite. A third-party project is needed if you want to auto-generate schema definitions.
Console is the place developers go to find the best tools. Each week, our weekly newsletter picks out the most interesting tools and new releases. We keep track of everything - dev tools, devops, cloud, and APIs - so you don't have to.
✦ Disclosure: All reviews are editorially independent and partners must meet our selection criteria.