pgTyped

pgtyped brings type safety to SQL queries in TypeScript by parsing SQL files and generating typed query functions. It analyzes SQL against your PostgreSQL schema and outputs TypeScript code that ensures inputs and results are correctly typed. This allows teams to use raw SQL while retaining the safety and developer experience of TypeScript.

Features

Parses SQL files to generate typed TypeScript queries
Ensures input/output types match the database schema
Supports parameterized queries and multiple result sets
Integrates with PostgreSQL using native protocol
Works with existing SQL files and codebases
Prevents runtime errors through static analysis

Project Samples

Project Activity

See All Activity >

License

MIT License

Follow pgTyped

pgTyped Web Site

Other Useful Business Software

Build Securely on AWS with Proven Frameworks

Lay a foundation for success with Tested Reference Architectures developed by Fortinet’s experts. Learn more in this white paper.

Moving to the cloud brings new challenges. How can you manage a larger attack surface while ensuring great network performance? Turn to Fortinet’s Tested Reference Architectures, blueprints for designing and securing cloud environments built by cybersecurity experts. Learn more and explore use cases in this white paper.

Download Now

Rate This Project

User Reviews

Be the first to post a review of pgTyped!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Programming Language

TypeScript

Related Categories

TypeScript SQL Clients

Registered

2025-06-04

Similar Business Software

DbVisualizer

DbVisualizer is a universal database client for anyone who works with data, from solo developers and startups to professional teams managing complex environments, including developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It offers a graphical interface...

See Software
KS DB Merge Tools

KS DB Merge Tools is an easy to use diff & merge tool for MySQL, MariaDB, Oracle Database, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS databases allowing to compare and sync both schema and data. Starting with a schema changes summary, results can be narrowed down to object lists of...

See Software
DbSchema

DbSchema is for visual designing the schema in a team, deploy and document the schema. Other integrated features like data explorer, visual query editor, data generator, etc., makes DbSchema an every-day tool for everybody who interacts with databases. DbSchema supports all relational and No-SQL...

See Software
QStudio

QStudio is a free, modern SQL editor supporting over 30 databases, including MySQL, PostgreSQL, and DuckDB. It offers features such as server browsing for easy viewing of tables, variables, functions, and configuration settings; SQL syntax highlighting; code completion; the ability to query...

See Software
AIHelperBot

Simple, powerful, and affordable. Generate SQL queries without prior SQL knowledge using everyday language. Just sign in and write what you desire using everyday language and AI Bot will build the desired SQL query. No coding is required, no SQL knowledge is required. Start a free trial and see...

See Software
DBeaver Community

DBeaver Community is a free, open-source database management tool recommended for personal projects. Manage and explore SQL databases like MySQL, MariaDB, PostgreSQL, SQLite, Apache Family, and more. Connect to popular SQL databases (PostgreSQL, MySQL, SQL Server, Oracle, SQLite, etc.) SQL...

See Software