Key Features of DbSchema

• Visual Schema Design: Create and manage database schemas with a visual interface. Design offline and deploy changes across different databases.
• Interactive HTML5 Documentation: Generate detailed schema documentation with interactive HTML5 diagrams. View table and column comments as mouse-over tooltips.
• Relational Data Explorer: Explore and visualize data across multiple tables. Bind tables with virtual foreign keys and view related records.
• Visual Query Builder: Build SQL queries visually using filters, ordering, and grouping. Simplify complex query creation without extensive SQL knowledge.
• Schema Synchronization: Compare and synchronize schema changes across databases. Generate SQL diff and migration scripts for updates.
• Data Generation: Create test data using a graphical interface with predefined patterns or custom regular expressions.
• SQL Editor: Write, edit, and execute SQL queries with syntax highlighting, auto-completion, and error checking.
• MongoDB Support: Visualize MongoDB schemas, implement validation rules, and write native MongoDB queries.
• Data Importer: Import data from CSV, Excel, XML, and JSON files with a user-friendly mapping interface.
• CSV Editor: Edit large CSV files (up to gigabytes) with filtering and sorting capabilities.
• Automation: Automate tasks using Java Groovy scripts with access to DbSchema’s API for schema reverse-engineering, deployment, and documentation generation.
• Dark Theme: Enjoy a dark theme for a more comfortable visual experience.
• Version Control Integration: Share schema designs using GIT for version control, ensuring data privacy and collaboration.

These features make DbSchema a powerful tool for database design, management, and documentation.