Dbtpl

Dbtpl - generate type-safe Go from SQL schemas | Awesome Repos

Features

Go Code Generators - Automatically generates idiomatic Go source code and type-safe data models from SQL database schemas.
Typesafe SQL Code Generators - Generates type-safe Go source code and data models from SQL database schemas and queries.
Output Format Definitions - The tool allows defining custom output formats by authoring or modifying base templates to match specific organizational requirements.
Database Introspection Tools - Provides utilities for reverse-engineering schema definitions from live databases across multiple SQL dialects.
Typesafe Query Generations - Generates type-safe query functions and result models from labeled SQL statements.
Database Schema Analyzers - Analyzes database catalogs across multiple SQL dialects to export structural definitions for development.
SQL-to-Go Struct Generators - Parses custom SQL queries to automatically create corresponding type-safe Go structs and execution functions.
Template-Based Code Generators - Uses dynamic text templates to automate the creation of source code and scripts from schema metadata.
Model Generators - Generates language-specific model structures, including Go structs, from database schemas.
Source Code Generators - Programmatically generates valid source code files and schema scripts from database representations.
Database Accessor Generators - Creates type-safe data models and accessor functions for tables, enums, and stored procedures.
Access Layer Templates - Allows defining specific code output formats using text templates to match organizational standards.
Django Model Definitions - Produces compatible model definitions for the Django web framework based on database schemas or SQL queries.
Platform-Specific Type Mappings - Maps vendor-specific database types into a common internal representation for consistent source code output.
Schema Documentation Generators - Produces structured reports, visual diagrams, and JSON/YAML representations of relational database schemas.
DDL Script Generators - Produces DDL scripts to recreate or mirror database schemas based on live introspection.
Migration Script Generators - Produces SQL migration scripts by introspecting a live database to recreate its schema.
SQL Statement Parsing - Parses custom SQL statements to automatically derive the necessary data types and execution functions.
Database Relationship Diagrams - Produces dot files that visualize database relationships and structural diagrams using graph visualization tools.
Generation Templates - Uses custom text templates to modify the structure, logic, and content of generated files.
Database Tools - Listed in the “Database Tools” section of the Awesome Go awesome list.

Open-source alternatives to Dbtpl

Similar open-source projects, ranked by how many features they share with Dbtpl.

knq/xo
knq/xo
3,890View on GitHub
xo is a tool for generating type-safe Go models and query execution code from SQL database schemas and queries. It functions as a multi-dialect SQL tool supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server to produce idiomatic source code. The project uses a template-based generation system, allowing the structure and logic of the generated database source code to be defined through customizable text templates. It also includes a database schema visualizer that analyzes table relationships and definitions to create visual diagrams and structured documentation. The tool's ca
Go
View on GitHub3,890
pingfangushi/screw
pingfangushi/screw
3,966View on GitHub
Screw is a database schema analysis tool used to automatically produce technical documentation and Java data objects. It scans database tables to export their definitions, transforming schema metadata into structured reports and application code. The project generates plain Java objects based on existing database table structures to automate data modeling. It also produces database schema documentation in HTML, Word, and Markdown formats. The system includes capabilities for table export filtering using name patterns, JDBC-based schema extraction, and template-based code generation to map da
Java
View on GitHub3,966
ariga/atlas
ariga/atlas
8,096View on GitHub
Atlas is a SQL database schema management tool and database infrastructure as code framework. It provides a declarative database migration engine that computes the difference between a desired schema state and the current database state to automatically generate the necessary SQL for transitions. The project distinguishes itself through a comprehensive suite of analysis and visualization tools, including a database schema linter that detects destructive changes and data loss risks. It also features a SQL schema visualization tool capable of generating entity-relationship diagrams from extract
Go
View on GitHub8,096
sqldelight/sqldelight
sqldelight/sqldelight
6,827View on GitHub
SQLDelight is a Kotlin database library that validates SQL schema, statements, and migrations at compile time, generating type-safe Kotlin query functions from labeled SQL files. It treats SQL as the source of truth for database definitions, catching schema errors during the build process before they reach production. The library supports multiple database dialects including SQLite, MySQL, PostgreSQL, HSQL, and H2, and generates platform-specific code for Android, iOS, JVM, and JavaScript targets. It provides a platform-specific driver abstraction that handles database connectivity difference
Kotlinkotlin-multiplatformsqlsqldelight
View on GitHub6,827

See all 30 alternatives to Dbtpl

xodbtpl

Features

Open-source alternatives to Dbtpl

knq/xo

pingfangushi/screw

ariga/atlas

sqldelight/sqldelight

Star history

Open-source alternatives to Dbtpl

knq/xo

pingfangushi/screw

ariga/atlas

sqldelight/sqldelight