Herramientas que generan automáticamente código e interfaces con seguridad de tipos directamente a partir de las definiciones de esquema de tu base de datos existente.
sqlc is a SQL compiler and code generator that creates type-safe database client code from raw SQL queries. It transforms SQL statements into typed definitions and functions, eliminating the need for manual row mapping between database results and application structures. The tool ensures compile-time safety by validating SQL queries against the database schema before the application is run. This workflow integrates the database schema directly into the application code, deriving types from the underlying SQL definitions to prevent runtime errors. The system utilizes AST-based query analysis
sqlc is a SQL compiler that generates type-safe client code (including TypeScript) from your SQL schema and queries, with support for multiple databases and custom type mappings, making it a strong fit for compile-time safe database interactions.
sqlc is a code generation tool that compiles raw SQL queries into type-safe application code. By analyzing SQL statements against database schema definitions during the build process, it eliminates the need for manual data mapping and prevents runtime type errors. The project functions as a schema-aware generator that translates database column types into native language primitives. It distinguishes itself through a modular, plugin-based architecture that allows for the extension of the generation pipeline to support diverse programming languages and custom frameworks beyond its default capab
sqlc is a schema-driven code generator that produces type-safe client code from SQL queries and schema definitions, which directly matches the core intent; however, its default language support does not include TypeScript (it covers Go, Python, Kotlin, etc.), so it may require additional plugin configuration to generate TypeScript types, placing it as a solid match rather than the most comprehensive answer for this specific need.
Prisma is a database toolkit that provides a unified access layer for interacting with relational and document databases. It centers on a declarative schema modeling approach, where developers define their data structures in a human-readable language. This schema serves as the single source of truth, from which the toolkit automatically generates type-safe database clients that provide compile-time validation and editor autocomplete for all data operations. The project distinguishes itself through a high-performance, Rust-based query engine that handles query planning and connection pooling o
Prisma is a database toolkit that generates type-safe TypeScript clients from a declarative schema, providing multi-database support, introspection, and custom type mapping — exactly what this search asks for.
Prisma is a type-safe database object-relational mapper that uses a declarative schema to map data models to relational and document databases. It provides a unified toolkit for data access, combining a database driver with tools for schema management and record manipulation. The project features a multi-database driver that standardizes interactions across PostgreSQL, MySQL, and MongoDB. It includes a system for tracking and applying structural schema migrations across different environments and a graphical user interface for browsing and editing database records. The system ensures data in
Prisma is a type-safe database ORM that generates TypeScript types from your database schema (supporting both introspection from an existing SQL database and explicit schema definitions), covering all the requested features like multi-database support, DB introspection, and custom type mapping.
Prisma1 is a TypeScript object-relational mapper and type-safe database client designed for interacting with relational databases. It functions as a system for declarative schema modeling, where database structures are defined in a single schema file that automatically synchronizes with the underlying database. The project provides a type-safe query builder that generates a custom client to ensure database queries match defined schema types at compile time. It also includes a database GUI administrator, providing a visual web interface for browsing, editing, and managing relational database r
Prisma1 generates a type-safe TypeScript client from a declarative schema or an existing database, with introspection, multi-database support, and custom type mapping, making it a comprehensive fit for your goal of automating type-safe database code.
jOOQ is a type-safe SQL query builder for Java that generates code from live database schemas, enabling compile-time validation of SQL syntax and data types. Its core identity is built around a fluent DSL that mirrors SQL structure, a code generator that maps tables, views, and routines to Java objects, and a multi-dialect engine that translates the same DSL into vendor-specific SQL for over 30 databases. The project also includes a SQL parser and transformer for refactoring or dialect conversion, reactive stream integration for non-blocking query execution, and a JDBC proxy diagnostics tool f
jOOQ is a type-safe SQL query builder that generates compile-time-checked Java code from live database schemas, making it the right kind of tool for safe database interactions; however it produces Java classes rather than TypeScript types, so it covers the core capability but misses your specific language target.
sqlboiler is a database-first ORM generator for Go that analyzes an existing database schema to produce strongly typed structures and query helpers. It functions as a schema-driven code generator, transforming database tables and relationships into executable Go source code. The project distinguishes itself through a type-safe query builder that uses chainable modifiers to construct SQL statements, eliminating the need for raw string concatenation. It utilizes customizable text templates to generate source code, allowing for the aliasing of schema entities and the creation of custom templates
Sqlboiler automatically generates type-safe Go code from your existing database schema through introspection—it matches the core idea of a schema-driven code generator, but you explicitly asked for TypeScript types instead of Go, so it delivers the right approach for a different target language.