dbForge Edge Features Overview

Documentation

Find technical information on product installation, activation, and utilization.

Release Notes

Discover the latest product launches, enhancements, and bug fixes.

AI Assistant

Integrated AI Assistant
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Context-aware query generation
Yes
Yes
Yes
Yes
Conversion of natural language to SQL
Yes
Yes
Yes
Yes
SQL troubleshooting
Yes
Yes
Yes
Yes
SQL explanations
Yes
Yes
Yes
Yes
Query optimization
Yes
Yes
Yes
Yes
Error analysis and recommendations
Yes
Yes
Yes
Yes
AI chat
Yes
Yes
Yes
Yes

Query writing and editing

SQL editing and execution
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
SQL Editor with syntax coloring
Yes
Yes
Yes
Yes
Automatic SQL syntax check
Yes
Yes
No
Yes
Code outlining
Yes
Yes
Yes
Yes
Customizable SQL formatting
Yes
Yes
Yes
Yes
Execute current statement
Yes
Yes
Yes
Yes
Quick access to favorite templates from SQL Editor
Yes
Yes
Yes
Yes
Bookmarks
Yes
Yes
Yes
Yes
Text search
Yes
Yes
Yes
Yes
Document Outline window for quick navigation through large scripts
Yes
Yes
Yes
Yes
One-step access to database object editors from the code ('Go to definition')
Yes
Yes
Yes
No
SQL history
Yes
Yes
Yes
Yes
Execution warnings
Yes
Yes
Yes
No
GUI transaction support
Yes
Yes
Yes
No
Code completion
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Context-aware code completion
Yes
Yes
Yes
Yes
Code snippets and Snippets Manager
Yes
Yes
Yes
Yes
One-click access to schema object definitions
Yes
Yes
Yes
No
On-the-fly renaming of database objects
No
Yes
No
No
Auto-generation of table aliases
Yes
Yes
Yes
Yes
Quick information about database objects
Yes
Yes
Yes
Yes
Parameter information for stored routines
Yes
Yes
Yes
Yes
Auto-generation of JOIN clauses
Yes
Yes
Yes
Yes
Code analysis
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
200+ rules in total
Yes
No
No
No
Best practice rules
Yes
No
No
No
Performance rules
Yes
No
No
No
Deprecated rules
Yes
No
No
No
Execution rules
Yes
No
No
No
Naming rules
Yes
No
No
No
Database projects
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
New project wizard with import from an existing database
No
Yes
Yes
No
Project Explorer window for managing project files
No
Yes
Yes
No
Schema View window for browsing logical project structures
No
Yes
Yes
No
Project export to one of the multiple scripts
No
Yes
Yes
No
Multiple build configurations
No
Yes
Yes
No
Single-click project deployment on the server
No
Yes
Yes
No
Comparison of projects with live databases
No
Yes
No
No

Data management

Data editor
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Copying of data with column headers for quick pasting to spreadsheets
Yes
Yes
Yes
Yes
Custom data filters of any complexity
Yes
Yes
Yes
Yes
Data Viewer window for browsing images, RTF, and binary cell values
Yes
Yes
Yes
Yes
Date/time editor with a visual interface
Yes
Yes
Yes
Yes
Foreign key lookup editor for easy editing of fields referencing other tables
Yes
Yes
Yes
Yes
Free copying of any block of data to the clipboard
Yes
Yes
Yes
Yes
Full-text search (Ctrl+F) in the data grid
Yes
Yes
Yes
Yes
Graphical Card View
Yes
Yes
Yes
Yes
Grouping by arbitrary columns
Yes
Yes
Yes
Yes
Incremental search (Ctrl+I) through the data grid
Yes
Yes
Yes
Yes
Large objects (LOB) editor
Yes
Yes
Yes
Yes
Multi-table query result set editing
Yes
Yes
Yes
No
Paginal data browsing for large result sets
Yes
Yes
Yes
Yes
Data printing
Yes
Yes
Yes
Yes
Quick filter available for each data cell
Yes
Yes
Yes
Yes
Record numbering option
Yes
Yes
Yes
Yes
Read-only state indication
Yes
Yes
Yes
Yes
Report, chart, and pivot building directly from the data editor
Yes
Yes
Yes
Yes
Visible column picker
Yes
Yes
Yes
Yes
Data export
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
CSV
Yes
Yes
Yes
Yes
XML
Yes
Yes
Yes
Yes
TXT
Yes
Yes
Yes
Yes
XLS
Yes
Yes
Yes
Yes
XLSX
Yes
Yes
Yes
Yes
PDF
Yes
Yes
Yes
Yes
DBF
Yes
Yes
Yes
Yes
HTML
Yes
Yes
Yes
Yes
RTF
Yes
Yes
Yes
Yes
JSON
Yes
Yes
Yes
Yes
Google Sheets
Yes
Yes
Yes
Yes
MDB (Microsoft Access)
Yes
Yes
Yes
Yes
ODBC
Yes
Yes
Yes
Yes
SQL
Yes
Yes
Yes
Yes
Data export from multiple tables
Yes
Yes
Yes
Yes
Data export from the command line
Yes
Yes
Yes
Yes
Data export templates
Yes
Yes
Yes
Yes
Data import
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
CSV
Yes
Yes
Yes
Yes
XML
Yes
Yes
Yes
Yes
TXT
Yes
Yes
Yes
Yes
XLS
Yes
Yes
Yes
Yes
XLSX
Yes
Yes
Yes
Yes
DBF
Yes
Yes
Yes
Yes
JSON
Yes
Yes
Yes
Yes
Google Sheets
Yes
Yes
Yes
Yes
MDB (Microsoft Access)
Yes
Yes
Yes
Yes
ODBC
Yes
Yes
Yes
Yes
Data import from the command line
Yes
Yes
Yes
Yes
Data import templates
Yes
Yes
Yes
Yes

Database Explorer

Intuitive Database Explorer
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Multiple database connections
Yes
Yes
Yes
Yes
Browsing and navigation through objects
Yes
Yes
Yes
Yes
Detailed object properties and data browsing in the Object Viewer window
Yes
Yes
Yes
Yes
Dependency tree browsing for each object
Yes
Yes
Yes
No
Quick template script generation for selected objects: SELECT, INSERT, etc.
Yes
Yes
Yes
Yes
'Send to' command for quick sending of tables to Query Builder, Report Designer, and other tools
Yes
Yes
Yes
Yes
Refactoring of database objects
No
Yes
No
No

Database operations and maintenance

Administration
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Database copying
Yes
Yes
No
No
Database backup and recovery
Yes
Yes
No
No
Database snapshots
Yes
Yes
Yes
No
Database backup to SQL and ZIP
No
Yes
No
No
Database backup as a scripts folder
No
Yes
No
No
Database backup from the command line
No
Yes
No
No
Schema & data comparison
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Comparison and synchronization of data in databases of virtually any size
Yes
Yes
Yes
Yes
Comparison of tables, views, procedures, functions, triggers, and events
Yes
Yes
Yes
Yes
Custom comparison keys
Yes
Yes
Yes
Yes
Filtering of comparison results
Yes
Yes
Yes
Yes
Generation of data synchronization scripts
Yes
Yes
Yes
Yes
Viewing of data differences per record
Yes
Yes
Yes
Yes
Exclusion of tables and records from synchronization
Yes
Yes
Yes
Yes
Saving and loading of comparison settings
Yes
Yes
Yes
Yes
Generation of comparison reports in HTML and Excel formats
Yes
Yes
Yes
Yes
Generation of comments
Yes
Yes
Yes
Yes
Specific options for tables, script objects, triggers, indexes, and constraints
Yes
Yes
Yes
Yes
Inclusion\exclusion of objects by mask
Yes
Yes
Yes
Yes
Data comparison and synchronization from the command line
Yes
Yes
Yes
Yes
User & session management
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Security Manager for handling user accounts and privileges
Yes
Yes
Yes
No
Session Manager for monitoring active server connections and tracing user sessions
No
Yes
Yes
No
Server Monitor
Yes
No
No
No

Development and design

Visual Query Builder
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Support for the SELECT statement
Yes
Yes
Yes
Yes
Support for the INSERT, UPDATE, and DELETE statements
Yes
Yes
No
Yes
State-of-the-art diagrams with zooming and keyboard support
Yes
Yes
Yes
Yes
Diagram preview and printing
Yes
Yes
Yes
Yes
Visual addition of sub-queries to any part of the main query
Yes
Yes
Yes
Yes
Query outline (displayed in the Document Outline window)
Yes
Yes
Yes
Yes
Visual editing of sub-queries
Yes
Yes
Yes
Yes
Expression builder for creating complex conditions
Yes
Yes
Yes
Yes
Drag-and-drop tables
Yes
Yes
Yes
Yes
Copy/Paste tables to diagrams
Yes
Yes
Yes
Yes
Undo/Redo
Yes
Yes
Yes
Yes
Database design
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Visual Database Designer
Yes
Yes
Yes
No
Visualization of tables, views, stored procedures, and functions
Yes
Yes
Yes
No
Easy access to database objects for viewing their properties
Yes
Yes
Yes
No
Support for IDEF1X notations
Yes
Yes
Yes
No
Support for IE notations
Yes
Yes
Yes
No
Customizable diagram view with skin support
Yes
Yes
Yes
No
Smart ER diagram layout
Yes
Yes
Yes
No
Diagram export to different image formats
Yes
Yes
Yes
No
Search for database objects on the diagram
Yes
Yes
Yes
No
Reorganization of diagram shapes with containers
Yes
Yes
Yes
No
Customizable diagram printing with a rich set of options
Yes
Yes
Yes
No
Optional display of table constraints, indexes, and triggers
Yes
Yes
Yes
No
Integration with the Document Outline window
Yes
Yes
Yes
No
Diagram navigation with the Diagram Overview window
Yes
Yes
Yes
No
Notes for adding comments to the diagram
Yes
Yes
Yes
No
Zoom in/out
Yes
Yes
Yes
No
Save/Load diagrams
Yes
Yes
Yes
No
Table Designer
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Flat table editor
Yes
Yes
Yes
Yes
Convenient editor for foreign keys
Yes
Yes
Yes
Yes
Partitioning
Yes
Yes
Yes
No
Full-text search on the column grid
Yes
Yes
Yes
No
Preview of changes in schemas
Yes
Yes
Yes
Yes
Heuristics that help define the data types of new columns
Yes
Yes
Yes
Yes
Object editors
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Check constraints
Yes
Yes
Yes
Yes
Foreign keys
Yes
Yes
Yes
Yes
Indexes
Yes
Yes
Yes
Yes
Stored functions
Yes
Yes
Yes
No
Stored procedures
Yes
Yes
Yes
No
Tables
Yes
Yes
Yes
Yes
Triggers
Yes
Yes
Yes
No
Views
Yes
Yes
Yes
No
Undo option for object editors
Yes
Yes
Yes
Yes
Performance tuning
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Visual SQL EXPLAIN plan
Yes
Yes
Yes
Yes
Session statistics
Yes
Yes
Yes
No
Query plan displayed in the tree view
Yes
Yes
Yes
Yes
Profiling history that can be saved for further analysis
Yes
Yes
Yes
Yes
Comparison of profiling results with highlighted differences
Yes
Yes
Yes
Yes
Printing of profiling results
Yes
Yes
Yes
Yes
Debugger
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Script debugging
Yes
Yes
Yes
No
Step Into, Step Over, and Step Out commands for step-by-step execution
Yes
Yes
Yes
No
Breakpoints for procedures, functions, triggers, and scripts
Yes
Yes
Yes
No
Call Stack window with navigation
Yes
Yes
Yes
No
Watches window for the evaluation of variables
Yes
Yes
Yes
No

Collaboration

Source Control
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Integration with Git, GitHub, SVN
Yes
Yes
No
No
Shared and dedicated database development models
Yes
Yes
No
No
Conflict resolution: Get Local and Get Remote
Yes
Yes
No
No
Version control of static data
Yes
Yes
No
No
History of changes
Yes
Yes
No
No
Data Generator
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Support for all column data types
Yes
Yes
Yes
Yes
Multiple test data generators with customization
Yes
Yes
Yes
Yes
SQL data integrity support
Yes
Yes
Yes
Yes
Multiple ways to populate databases with test data
Yes
Yes
Yes
Yes
Meaningful generators
Yes
Yes
Yes
Yes
User-defined generators
Yes
Yes
Yes
Yes
Real-time preview of generated data
Yes
Yes
Yes
Yes
Data generation from the command line
Yes
Yes
Yes
Yes
Documenter
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Broad picture of database structures
Yes
Yes
Yes
No
Rich customization features
Yes
Yes
Yes
No
Export of documentation to HTML
Yes
Yes
Yes
No
Export of documentation to PDF
Yes
Yes
Yes
No
Export of documentation to Markdown
Yes
Yes
Yes
No
Customization of documentation with style templates
Yes
Yes
Yes
No
View inter-object and inter-database dependencies
Yes
Yes
Yes
No
Generation of documentation from the command line
Yes
Yes
Yes
No

Analysis

Data analysis
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Display of table data with parent-child dependencies in Master-Detail Browser
Yes
Yes
Yes
Yes
Database diagrams
Yes
Yes
Yes
No
Data report generation wizard
Yes
Yes
Yes
Yes
Report Designer
Yes
Yes
Yes
Yes
Pivot Table Designer
Yes
Yes
Yes
Yes
Chart building wizard
Yes
Yes
Yes
Yes
Data search on a live database
Yes
Yes
Yes
No
Automated generation and distribution of reports from the command line
Yes
Yes
Yes
Yes

User interface

Intuitive user interface
SQL Server
MySQL / MariaDB
Oracle
PostgreSQL
Start Page with quick access to key features
Yes
Yes
Yes
Yes
Rich user settings
Yes
Yes
Yes
Yes
UI skins
Yes
Yes
Yes
Yes
Customizable window layout
Yes
Yes
Yes
Yes
Tool windows with 'auto-hide' and 'float' modes
Yes
Yes
Yes
Yes
Multiple shortcut schemes with full shortcut customization
Yes
Yes
Yes
Yes
Syntax highlighting customization
Yes
Yes
Yes
Yes
Tabbed groups for documents
Yes
Yes
Yes
Yes
Toolbar customization
Yes
Yes
Yes
Yes
Wizard for sharing common code standards and templates
Yes
Yes
Yes
Yes

Compatibility

Databases

  • SQL Server
  • MySQL
  • MariaDB
  • Oracle
  • PostgreSQL
  • Galera Cluster
  • Percona
  • Greenplum DB

Cloud services

  • Supabase
  • Google Cloud Platform
  • Microsoft Azure SQL
  • Heroku
  • Oracle Cloud
  • Amazon Redshift
  • Amazon RDS
  • Amazon Aurora
  • TimescaleDB
  • Alibaba Cloud
  • AlloyDB
  • Tencent Cloud
  • YugabyteDB
  • Aiven Cloud
  • Neon.tech
  • IBM Cloud for PostgreSQL

Ready to get started?

Get started with a free trial of dbForge Edge

Download dbForge Edge for a free trial today!

Get a free trial of dbForge Edge to evaluate all of its capabilities hidden under a sleek user interface.

Download for free
dbForge Edge

Wield the full firepower of dbForge Edge

Go with the fully-functional Enterprise edition of dbForge Edge and stay at the top of your game from day one!

Purchase now