Fully type-safe
raw SQL
TypedSQL is the best way to express the full power of SQL in queries. Fully type-safe, with auto-completion, and a fantastic DX for using raw SQL with Prisma.
End-to-end
type-safety
All TypedSQL queries have typed inputs and outputs preventing errors related to incorrect types and improving DX. Any type mismatches can be caught right away, while type-safety significantly improves ergonomics while developing.
Full control
of SQL
When you need the full control of the SQL engine, write and execute raw SQL queries directly. This gives you the flexibility to use advanced SQL-specific features and optimizations that are not available in the Prisma Client API, while maintaining type safety.
Great DX
TypedSQL combines the productivity of a higher-level abstraction with type-safety for crafting SQL directly. Use familiar SQL tools in your editor, complete with syntax highlighting, error checking, and autocompletion.
See TypedSQL in action
Expand your capabilities
Built on Prisma Client, TypedSQL pairs well with all Prisma products and features.
Works alongside Prisma Schema & Migrate
TypedSQL complements Prisma Schema and Prisma Migrate. It extends the functionality you're already used to with type-safe SQL queries.
Use with Prisma Accelerate
Continue using SQL queries while benefiting from products built for Prisma Client, such as connection pooling and caching provided by Accelerate.