Awesome GitHub RepositoriesDatabase Administration CLI

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

Osmedeus is a security workflow orchestration engine that coordinates AI agents, shell commands, and scanning tools through declarative YAML pipelines. It functions as a distributed security scanner, a declarative workflow automator, and an AI agent framework for security, enabling automated multi-step security analysis with conditional branching, parallel execution, and distributed workers. The engine distinguishes itself through a hybrid runner model that executes workflow steps on the local host, inside Docker containers, or over SSH to remote machines, selected per step or module. It supp

pgloader is a command-line tool that automates the migration of data and schema from various source databases and file formats into PostgreSQL. It combines schema discovery, parallel data pipelines, and type casting into a single, declarative workflow, using PostgreSQL's COPY protocol for high-throughput bulk loading. The tool distinguishes itself by compiling a dedicated command language into concurrent reader-writer pipelines that handle schema introspection, data transformation, and error-resilient batch processing. It supports migrating entire databases from MySQL, MS SQL, SQLite, and Pos

CodeIgniter is a PHP web framework built on the Model-View-Controller pattern, designed for building full-stack web applications. It provides a lightweight toolkit with minimal configuration, organizing application logic into controllers, models, and views for clean separation of concerns. The framework includes a fluent query builder for constructing SQL statements programmatically, PSR-4 autoloading with namespace mapping, and a service-based dependency injection container for managing shared class instances. The framework distinguishes itself through its comprehensive set of built-in tools

Tortoise ORM is an asynchronous object-relational mapper for Python that mirrors Django's model and queryset API while running on asyncio. It defines database tables as Python classes with typed fields and supports foreign key, many-to-many, and one-to-one relations, providing a chainable query API for filtering, annotating, grouping, and prefetching related objects without blocking the event loop. The ORM includes a built-in migration engine that detects model changes, generates migration files, and applies or reverts schema changes through a command-line tool. It connects to PostgreSQL, MyS

DoctrineBundle هو تكامل لـ Symfony يقوم بتهيئة وإدارة Doctrine Object Relational Mapper وطبقة تجريد قاعدة البيانات. يوفر الأدوات الأساسية المطلوبة لتعيين كائنات التطبيق إلى جداول قاعدة بيانات علائقية وتنفيذ استعلامات خام من خلال واجهة برمجية متسقة. يتضمن المشروع مديراً لمخطط قاعدة البيانات مع أدوات سطر أوامر لمزامنة هياكل قاعدة البيانات مع تعيينات الكيانات وتنفيذ عمليات الترحيل. كما يوفر مصحح أخطاء استعلامات قاعدة البيانات وأدوات تصحيح الأخطاء لتتبع الأداء وتفاصيل التنفيذ عبر واجهة تعتمد على الويب. تغطي الحزمة مجموعة واسعة من إمكانيات إدارة البيانات، بما في ذلك تهيئة تعيين البيانات الوصفية، وتصفية الاستعلامات العالمية، وإنشاء معرفات كيانات مخصصة. كما تدعم تحسين الأداء من خلال التخزين المؤقت لنتائج الاستعلام وتوفر نظاماً قائماً على الأحداث لاعتراض تغييرات قاعدة البيانات ودورة حياة الكيانات.

ingestr is a command-line tool for copying and syncing data between different database engines and third-party platforms without writing custom code. It functions as an ETL pipeline utility that extracts data from diverse sources and loads it into destinations. The tool features a schema-agnostic data loader that maps source fields to destination columns dynamically, removing the need for predefined static table definitions. It also operates as an incremental data synchronizer, updating destination tables by appending new records or merging changes to maintain current datasets. The system pr

pg-boss is a background task scheduler and distributed task queue that uses PostgreSQL as a reliable message broker for asynchronous job processing. It provides a system for distributing work across multiple application instances, ensuring exactly-once delivery through atomic database transactions. The project includes a cron job scheduler for automating recurring tasks and a PostgreSQL pub-sub system for fan-out event distribution. It also features a web-based management dashboard for monitoring queue statistics and controlling job lifecycles, including manual retries and cancellations. Cap

Ebean is a Java object-relational mapping framework designed to simplify database persistence through automated query generation, schema migration, and transaction management. It uses metadata-driven mapping and bytecode enhancement to bridge the gap between application objects and relational database tables, providing a persistent layer that handles complex data interactions while maintaining consistency across unit-of-work boundaries. The framework distinguishes itself through its focus on developer productivity and performance optimization. It provides type-safe query builders that generat

TypeORM Seeding is a development utility designed to automate database population and schema management within TypeORM-based projects. It provides a framework for resetting database structures and injecting consistent data, facilitating predictable states for testing and local development environments. The tool distinguishes itself through a factory-based approach to data generation, allowing developers to define reusable templates that produce randomized entity records. By integrating directly with the existing database abstraction layer, it ensures that generated objects are persisted into