awesome-repositories.com
Blog
MCP
awesome-repositories.com

Discover the best open-source repositories with AI-powered search.

ExploreCurated searchesOpen-source alternativesSelf-hosted softwareBlogSitemap
ProjectMCP serverAboutHow we rankPress
LegalPrivacyTerms
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
xo avatar

xo/dbtpl

0
View on GitHub↗

Dbtpl

dbtpl is a database model generator and schema introspector that produces type-safe source code and data models from SQL database schemas. It functions as a command line tool that maps SQL types to Go structs and execution functions, while providing a template-based system for creating custom source code and schema definitions.

The tool supports multiple database engines, including PostgreSQL, MySQL, SQLite, Oracle, and SQL Server. It distinguishes itself by allowing users to define custom output formats through text templates and the ability to generate compatible model definitions for the Django web framework.

Its capabilities extend to producing SQL scripts for database migration and mirroring, as well as exporting schema representations in JSON or YAML formats. Additionally, it can generate dot files to visualize database relationships and structural diagrams.

AI search

Explore more awesome repositories

Describe what you need in plain English — the AI ranks thousands of curated open-source projects by relevance.

Start searching with AI

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.
3,892 stars·334 forks·Go·MIT·11 views

Star history

Star history chart for xo/dbtplStar history chart for xo/dbtpl

How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.

Projects sharing features with Dbtpl

These projects share indexed features with Dbtpl. Shared tags can include platform or build tooling; verify the primary use case before treating a result as a replacement.
  • knq/xoknq avatar

    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 GitHub↗3,890
  • pingfangushi/screwpingfangushi avatar

    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 GitHub↗3,966
  • koxudaxi/datamodel-code-generatorkoxudaxi avatar

    koxudaxi/datamodel-code-generator

    3,943View on GitHub↗

    This project is a command-line schema-to-code converter designed to transform diverse data specifications into type-safe Python data structures. It functions as a generator for Pydantic models, dataclasses, and typed dictionaries, enabling developers to maintain synchronization between evolving data contracts and application code. By parsing formats such as JSON Schema, OpenAPI, AsyncAPI, Protobuf, and Avro, the tool automates the creation of native classes that reflect the constraints and metadata defined in the source specifications. The generator distinguishes itself through a highly confi

    Pythoncode-generatorcsvdataclass
    View on GitHub↗3,943
  • ariga/atlasariga avatar

    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 GitHub↗8,096
Compare all 30 related projects→

Frequently asked questions

What does xo/dbtpl do?

dbtpl is a database model generator and schema introspector that produces type-safe source code and data models from SQL database schemas. It functions as a command line tool that maps SQL types to Go structs and execution functions, while providing a template-based system for creating custom source code and schema definitions.

What are the main features of xo/dbtpl?

The main features of xo/dbtpl are: Go Code Generators, Typesafe SQL Code Generators, Output Format Definitions, Database Introspection Tools, Typesafe Query Generations, Database Schema Analyzers, SQL-to-Go Struct Generators, Template-Based Code Generators.

Which projects share features with xo/dbtpl?

Projects with overlapping indexed features include: knq/xo — xo is a tool for generating type-safe Go models and query execution code from SQL database schemas and queries. It… pingfangushi/screw — Screw is a database schema analysis tool used to automatically produce technical documentation and Java data objects.… koxudaxi/datamodel-code-generator — This project is a command-line schema-to-code converter designed to transform diverse data specifications into… ariga/atlas — Atlas is a SQL database schema management tool and database infrastructure as code framework. It provides a… sqldelight/sqldelight — SQLDelight is a Kotlin database library that validates SQL schema, statements, and migrations at compile time,… oapi-codegen/oapi-codegen — oapi-codegen is an OpenAPI specification compiler and code generator for Go. It transforms OpenAPI definitions into…