Awesome GitHub RepositoriesSQL Export Generators

cloc is a codebase metrics tool and multi-language code analyzer designed to count blank lines, comment lines, and physical lines of code. It serves as a source code line counter and report generator that identifies file types to calculate source volume across a wide variety of programming languages. The tool distinguishes itself by providing codebase version comparison to measure relative changes in source and comment lines between two versions of a directory or archive. It also supports the definition of custom languages and the extension of language recognition by loading custom comment fi

pgcli is an interactive command-line interface and database management tool for PostgreSQL. It functions as an interactive SQL shell and query editor that allows users to inspect schemas, manage connections, and run queries against PostgreSQL data sources. The tool is distinguished by its real-time, schema-aware autocompletion for keywords, tables, and columns, as well as dynamic SQL syntax highlighting. It provides safety mechanisms through transaction-aware guardrails that warn against or block destructive statements when no active transaction is detected. Broad capabilities include secure

This project is an administrative GIS toolset that provides a comprehensive dataset of China's administrative divisions, including provinces, cities, districts, and townships. It functions as a coordinate system transformer and a boundary converter for transforming geographic data into standard formats. The toolset distinguishes itself through the ability to convert administrative boundary data between CSV, GeoJSON, Shapefiles, and SQL. It includes specialized utilities for coordinate system transformation between GCJ-02, BD-09, WGS-84, and CGCS2000 standards to ensure accuracy across differe

SQLiteStudio is an open-source graphical tool for browsing, editing, and managing SQLite database files. It combines a full-featured SQL editor with syntax highlighting, a visual database schema designer for creating entity-relationship diagrams, and a plugin-based extensibility platform that allows adding custom functionality through C/C++, JavaScript, Tcl, or Python. The application distinguishes itself through its multi-language scripting engine, which embeds JavaScript, Tcl, and Python interpreters to enable user-defined functions and scripts within SQL queries. It supports encrypted data

Alembic es un sistema de versionado de esquemas de base de datos y herramienta de migración para SQLAlchemy. Gestiona actualizaciones incrementales a las estructuras de base de datos utilizando scripts versionados que admiten tanto la actualización como la degradación para mantener la base de datos y el código sincronizados. El sistema utiliza un grafo acíclico dirigido para la gestión de migraciones, lo que permite un versionado no lineal, incluyendo ramificación y fusión a través de múltiples versiones raíz. Incluye una herramienta automatizada de comparación de esquemas que compara esquemas de bases de datos en vivo contra objetos de metadatos para generar programáticamente instrucciones de migración. La herramienta proporciona capacidades para la evolución transaccional de esquemas para asegurar actualizaciones atómicas y prevenir la corrupción parcial de la base de datos. La funcionalidad adicional incluye la traducción de directivas de migración a cadenas SQL sin procesar para auditoría y el mantenimiento del seguimiento de versiones basado en scripts a través de una tabla de base de datos dedicada.