dbgate/dbgate
Dbgate
DbGate is a universal database management tool and SQL client that provides a unified interface for querying and administering multiple SQL and NoSQL databases. It functions as a multi-database administration GUI and SQL IDE, allowing users to write and execute scripts and manage database schemas.
The project distinguishes itself by acting as an API client and explorer for REST, GraphQL, and OData services, enabling users to fetch and export data from these endpoints. It also serves as a data integration tool, facilitating the movement of records between diverse databases and file formats such as CSV, JSON, XML, and Excel.
The platform covers broad capability areas including data visualization through ER diagrams and geospatial mapping, schema administration with structure comparison and model deployment, and secure connectivity via SSH tunneling and identity provider integration. It also supports automation through the generation of data migration and database operation scripts.
The application is designed for multi-platform deployment, running as a native desktop application, a web-based service, or within Docker containers.
Features
- Database Management GUIs - Provides a comprehensive graphical interface for managing schemas and performing migrations across multiple database engines.
- SQL Query Execution - Provides a comprehensive interface for executing, formatting, and managing SQL queries across multiple database engines.
- Multi-Database Connections - Provides a unified interface to query and manage multiple relational, NoSQL, and document databases simultaneously.
- Cross-Database Data Migrations - Facilitates moving records between diverse databases and file formats like CSV, JSON, and Excel.
- Data Export - Reads database tables and writes results to CSV or XML using specialized plugins.
- Data Import and Export - Provides utilities for moving data between databases and standard formats like CSV, Excel, JSON, and XML.
- Data Import Utilities - Loads external data files into a database using a configurable mapping tool.
- Database Connection Managers - Manages connections to multiple diverse database types and local SQLite files.
- Database Connector Plugins - Implements a plugin architecture to integrate specific database connectors and drivers.
- Database Connection Configurations - Provides detailed configuration for server connectivity, authentication, and network tunneling.
- Schema Modification - Edits table structures, indexes, and keys to manage the database architecture.
- Database Management Tools - Provides a unified interface for querying and administering various SQL and NoSQL databases.
- Data Record Editing - Provides visual interfaces for filtering, modifying, and managing table records with change previews.
- File-Based Data Exports - Writes database table content to specific file formats using dedicated format providers.
- Schema Comparison Tools - Analyzes differences between database schemas and synchronizes them to keep environments consistent.
- SQL Query Editors - Provides an interactive SQL editor with formatting and developer aids for writing and executing queries.
- Integrated Script Editors - Ships a built-in code editor with completion and formatting for SQL, MongoDB, and Redis scripts.
- Interactive API Explorers - Provides an interactive explorer to fetch and export data from REST, GraphQL, and OData APIs.
- SQL Development Environments - Offers an integrated environment for writing, executing, and optimizing SQL scripts with visual query design.
- Plugin-Based Architectures - Uses a modular plugin system to encapsulate database-specific connection and query logic.
- Cross-Source Joins - Performs analytical joins across disparate database servers within the application layer.
- Filtering - Writes table or query results to a file while applying active filters to the dataset.
- Database Content Archiving - Archives database contents into NDJSON files on a local filesystem or remote server.
- Grid Data Filters - Isolates specific records in result sets using value selectors and custom logical expressions.
- Memory-Efficient Data Streaming - Moves records between sources and destinations using a pipeline of readers and writers to handle large datasets efficiently.
- Archive-to-Database Replication - Enables copying data from local archives into a database via graphical or command-line interfaces.
- Geographic Data Mapping - Renders spatial columns or coordinates from database records as interactive markers on a map.
- Data Synchronization - Compares and aligns data between local archives and active databases to ensure consistency.
- Data Visualization - Generates ER diagrams and master/detail views to visualize relational database structures.
- Database Backups - Creates copies of database state and reinstates them to prevent data loss.
- Encrypted Connections - Configures SSL/TLS encryption for database connections to ensure data is protected while in transit.
- Schema Model Deployment - Deploys database schemas defined in YAML and SQL files to target database servers.
- Database Drivers - Allows adding support for new database types by implementing custom connectivity drivers.
- Schema Model Export - Extracts current database structures into YAML and SQL files for future deployment and versioning.
- Database Schema Managers - Provides tools for defining, comparing, and managing database structures across different server environments.
- Database Task Automation - Generates and exports scripts from configured workflows to run database tasks programmatically.
- Migration Generation - Transpiles import and export jobs into standalone scripts for independent execution.
- Model-to-Database Comparisons - Visualizes structural differences between a defined schema model and a live database to identify changes.
- OData Service Querying - Enables data retrieval from OData services using standard query syntax.
- Query Result Visualizers - Generates charts from SQL query data to represent database results as visual graphics.
- Schema Synchronizers - Synchronizes database structures with defined models by creating missing tables and columns.
- SQL Script Execution - Executes sequenced SQL scripts for database updates with execution history tracking.
- Visual Query Builders - Includes a graphical designer that allows users to construct complex SQL queries without writing manual code.
- Remote Configuration Databases - Stores configuration and user metadata in an external database to synchronize environments across teams.
- REST API Clients - Functions as a client for interacting with RESTful services using OpenAPI specifications.
- Containerized Application Deployments - Packages the entire application as a Docker image for consistent cross-environment deployment.
- Multi-Runtime Deployment - Runs as a native desktop application, a web-based service, or within Docker containers from a shared codebase.
- Unified Multi-Platform Deployment - Supports running as a native desktop application, a web-based service, or within Docker containers.
- Geospatial Visualizations - Renders database coordinates and spatial columns as interactive markers and maps.
- Authentication Providers - Integrates with external identity providers including OAuth, LDAP, and Active Directory for authentication.
- Identity Provider Integrations - Integrates with external identity providers such as OAuth, Active Directory, and LDAP for user authentication.
- SSH Tunneling - Allows routing database traffic through secure SSH tunnels to access servers located behind firewalls.
- OAuth Authentication - Implements OAuth 2.0 flows to verify user identities via third-party providers before granting application access.
- Role-Based Access Control - Assigns permissions and connection access to roles for granular control over database objects and schemas.
- Extensible Plugin Architectures - Implements an extensible plugin architecture to add custom capabilities and modular components.
- Database-to-Database Transfers - Copies data from a source reader to a destination writer to move table data.
- Querying and Introspection - Provides the ability to execute queries and perform schema introspection on GraphQL data sources.
- YAML-Based - Defines database structures and deployment models in YAML files to enable platform-independent versioning.
- Database Management - Database manager supporting multiple SQL and NoSQL engines.
- Database GUIs - Database manager for various SQL and NoSQL systems.
