Awesome GitHub RepositoriesData Seeding Utilities

Payload is a headless content management system and application framework that uses a code-first approach to define data schemas and administrative interfaces. By utilizing a centralized, type-safe configuration object, it automatically generates database schemas, API endpoints, and a fully customizable admin panel. The system is built on a database-agnostic architecture, allowing it to interface with various storage engines while providing a unified, type-safe API for server-side operations, REST, and GraphQL. What distinguishes Payload is its deep extensibility and developer-centric design.

graphql-engine is an automated GraphQL API engine that transforms database tables and relationships into a queryable GraphQL schema. It functions as a federation gateway and mapper, instantly generating APIs with built-in filtering, pagination, and mutations from existing databases and remote schemas. The project distinguishes itself through a fine-grained access control layer that enforces row-level and field-level permissions. It further provides a real-time data subscription server that converts standard queries into live streams and a system for triggering event-driven webhooks and notifi

This project is a comprehensive link management and marketing attribution platform designed for creating, tracking, and analyzing shortened URLs. It functions as a centralized hub for marketing analytics, providing tools to monitor link performance, visualize conversion funnels, and manage affiliate programs through a unified dashboard. The platform distinguishes itself by integrating advanced attribution modeling and partner management directly into the link infrastructure. It supports complex marketing workflows, including automated commission calculations, fraud detection, and payout distr

Knex is a multi-dialect database client that provides a programmatic SQL query builder, a connection pool manager, and a versioned schema migration tool. It enables programmatic database interaction across multiple SQL engines, including PostgreSQL, MySQL, SQLite3, SQL Server, CockroachDB, and Oracle. The project distinguishes itself through a fluent interface for constructing complex SQL statements and a dedicated framework for database seeding. It utilizes specialized dialects to translate generic query representations into database-specific syntax while maintaining a consistent API across

Dapper is a lightweight object-relational mapper for .NET that functions as a high-performance data access library. It operates by extending standard database connection interfaces, allowing developers to execute raw SQL queries while automating the mapping of database results to strongly-typed objects. The library distinguishes itself through its use of runtime code generation, which creates high-performance instructions to map database rows to object properties with minimal overhead. It provides flexible data retrieval options, supporting both memory-buffered loading for speed and row-by-ro

Wasp is a declarative full-stack web framework that enables developers to build and deploy applications by defining their architecture in a centralized configuration. By using a high-level specification, the framework automates the orchestration of frontend, backend, and database components, ensuring that infrastructure concerns like routing, authentication, and data modeling are handled consistently across the entire stack. The framework distinguishes itself through its compiler-driven approach, which translates declarative configurations into cohesive, production-ready codebases. It provide

Faker is a library for generating synthetic data and mock information to populate development and testing environments. It provides a structured way to create realistic values such as names, addresses, and dates, allowing developers to validate application logic and visualize user interfaces without relying on production data. The library distinguishes itself through its support for deterministic generation, which uses fixed seeds to ensure that data sequences remain identical across multiple test executions. It also features a modular architecture that separates generation logic into indepen

Entity Framework Core is an object-relational mapper that enables developers to interact with database systems using strongly-typed code. It serves as a comprehensive data access framework, providing a unified interface for mapping application objects to relational and non-relational database schemas while managing the lifecycle of data operations through a central context. The project distinguishes itself through a provider-based architecture that decouples core data access logic from specific database engines, allowing for consistent interaction across diverse storage systems. It features a

This project is a self-hosted, cross-platform instant messaging platform featuring a Go backend and a protobuf-based messaging server. It provides a unified communication suite with native clients for iOS, Android, and web, utilizing gRPC and Protocol Buffers for efficient data exchange. The system is distinguished by an extensible chatbot framework that allows for the integration of automated bots and plugins via standardized service interfaces. It supports high-availability clustering with sharded load distribution and a pluggable database backend to ensure reliability and flexible data per

This is a reference implementation library providing a collection of code samples, Transact-SQL scripts, and schemas for SQL Server, Azure SQL, and Azure Synapse. It focuses on providing standardized implementation patterns and reference code for building relational databases and cloud data warehouses. The library distinguishes itself by offering specialized guides and examples for deploying database instances within containerized environments and Azure cloud services. It includes specific reference databases and language extensions for integrating machine learning services and advanced analy

Goose is a database schema versioning system and SQL migration tool designed for Go applications. It functions as a framework for tracking and applying incremental database changes through versioned SQL scripts, ensuring consistency across different environments. The project distinguishes itself by providing a build-time capability to exclude unused database drivers to optimize binary size and a filesystem abstraction that allows migration scripts to be bundled directly into a compiled executable. It also supports out-of-order execution logic to apply missing scripts that were created after a

Mikro-ORM is a TypeScript-based object-relational mapping system that provides a unified persistence layer for Node.js applications. It translates TypeScript entities into relational or document-based database schemas, supporting a variety of engines including PostgreSQL, MySQL, MariaDB, MS SQL Server, SQLite, and MongoDB. The project implements the data mapper pattern to decouple in-memory domain models from the database persistence layer. It utilizes a unit of work pattern to track entity changes in memory and commit them in a single coordinated database transaction. The library covers com

Admin-bro ist ein Node.js-Framework für Administrations-Panels, das Datenbankschemata automatisch in funktionale Content-Management-Systeme und Backend-Dashboards umwandelt. Es bietet eine visuelle Schnittstelle für Create-, Read-, Update- und Delete-Operationen (CRUD) auf Datensätzen über verschiedene unterstützte Datenquellen hinweg. Das Framework nutzt modellgesteuerte UI-Generierung, um Datenbank-Metadaten auf Formular-Komponenten abzubilden, und verwendet eine adapterbasierte Abstraktionsschicht, um administrative Operationen in spezifische Datenbankabfragen zu übersetzen. Es unterstützt die Ausführung benutzerdefinierter Geschäftslogik und operativer Workflows durch aktionsbasierte Trigger, die mit spezifischen Ressourcen-Datensätzen verknüpft sind. Das System umfasst Funktionen zur Datenvisualisierung mittels administrativer Dashboards und Business-Intelligence-Reporting. Es bietet zudem Werkzeuge für schemabasierte Eingabevalidierung, die Erweiterung von Ressourcen-Metadaten mittels Decorators sowie eine pluginbasierte Architektur zum Hinzufügen benutzerdefinierter Interface-Komponenten.

AdminJS is a Node.js admin panel and database management UI that provides a visual interface for performing create, read, update, and delete operations based on existing database models. It functions as a low-code backend dashboard and internal tool builder, allowing developers to create management interfaces for monitoring and controlling application state without writing custom frontend code. The project enables the creation of custom business logic workflows and system dashboards, providing non-technical team members with a secure way to manage application data. It supports the development

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

SEO Machine is an open-source content workflow tool that orchestrates a multi-agent pipeline to research, write, optimize, and publish SEO-friendly articles. It coordinates specialized AI agents in sequence, handling everything from keyword research and competitor analysis through long-form article generation, content health scoring, and direct CMS publishing. The system is driven by local configuration files that preserve brand voice, style guide, and SEO rules across all generated content. It integrates with Google Analytics 4, Google Search Console, and DataForSEO to pull real-time perform

Phinx ist ein PHP-Tool für Datenbankmigrationen und Versionierung, das dazu verwendet wird, strukturelle Änderungen an Datenbankschemata über verschiedene Umgebungen hinweg zu verfolgen und bereitzustellen. Es fungiert als Versionskontrollsystem für Datenbanken und ermöglicht es, strukturelle Modifikationen durch PHP-Code zu definieren und zu verwalten. Das Tool bietet Mechanismen für die Versionierung und das Rollback von Datenbankschemata, wodurch Benutzer zuvor angewendete Migrationen rückgängig machen und eine Datenbank in einen bestimmten vorherigen Zustand zurückversetzen können. Zusätzlich enthält es einen Datenbank-Seeder zum Befüllen von Tabellen mit initialen Basisdatensätzen oder Dummy-Daten. Das System arbeitet als eigenständige Kommandozeilenschnittstelle, die die sequentielle Ausführung von Migrationen verwaltet und die aktuelle Schemaversion über eine Metadatentabelle innerhalb der Zieldatenbank nachverfolgt.

Replibyte is a tool that automates the lifecycle of database snapshots for non-production environments, handling the export, anonymization, subsetting, and restoration of data. It is designed to support privacy-compliant development workflows by replacing sensitive production data with synthetic values and extracting consistent subsets of rows while preserving referential integrity. The tool operates through a configurable pipeline defined in a YAML file, orchestrating stages such as dump, anonymize, subset, and restore. Each operation runs as an isolated, ephemeral container job, and snapsho

bknd is a self-hosted backend-as-a-service platform and serverless backend framework that provides an integrated environment for managing databases, authentication, and file storage. It functions as a headless CMS and a portable API engine designed to run across various JavaScript runtimes, including Node.js, Bun, Cloudflare Workers, and AWS Lambda. The project distinguishes itself through a combination of schema-driven API generation and a built-in database management UI. It enables the definition of data structures either programmatically via a type-safe API or visually through an administr

Gauzy is an open business management platform and multi-tenant enterprise resource planning system. It provides a modular business framework designed to manage core organizational operations through a unified web interface or as a headless business API. The platform is distinguished by its integration with the Model Context Protocol, allowing it to act as a server that exposes business data and system functions as tools for AI assistants. It utilizes a dynamic plugin architecture and a dedicated marketplace to extend core business entities and services. The system covers a broad range of ope