Typesafety

Pgtyped generates TS types for parameters and results of SQL queries of any complexity.

Parse SQL and TS files

Queries can be written in SQL files together with useful parameter annotations. In Typescript files, queries can be defined using a sql template string literal.

Prevent SQL injections

PgTyped prevents SQL injections by separately sending queries and parameters to the DB for execution. This allows parameter substitution to be safely done by the PostgreSQL server