issues faster

Database Tools

Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration

Data Connectivity

The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components

Productivity Tools

Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions

Data Services

Data integration, online backup, web-based SQL tools, cloud connectivity solution

Data Editor

  • Asynchronous data fetch with ability to cancel the operation
  • Batch table update mode when changes are accumulated and applied explicitly
  • Copying data with column headers for quick paste to spreadsheet
  • Custom data filters of any complexity
  • Large objects (LOB) viewer
  • Date time editor with visual interface
  • Foreign key lookup editor for easy editing of fields referencing other tables
  • Full-text search (Ctrl+F) through data grid
  • Graphical card view
  • Incremental search (Ctrl+I) through data grid
  • Multi-table query result set editing
  • Paginal data browsing for large result sets
  • Quick filter feature available for each data cell
  • Read-only state indication
  • Server-side sorting and filtering to help dealing with large data sets
  • Visible columns picking dialog box
  • Editing microseconds in columns with TIME, DATETIME and TIMESTAMP

Database Explorer

  • Multiple database connections allowed
  • Asynchronous connect to server with ability to cancel the operation
  • Detailed object properties and data browsing in Object Viewer window
  • Quick template script generation for selected object: SELECT, INSERT, EXECUTE, etc
  • 'Send To' command for quick sending of tables to Query Builder
  • Multi-selection for batch operations on objects
  • Database navigation history
  • Expanded support of indexes and columns in tables
  • Displaying the objects number

Exporting Data

  • Data export to: CSV, DBF (Foxpro, dBase III, dBase IV, dBase 7), HTML, MDB (Microsoft Access), ODBC, PDF, RTF, SQL, Text, XML, XLS (Microsoft Excel), XLSX (Microsoft Excel 2007+), JSON, and Google Sheets
  • Export data from multiple tables at once
  • Templates for export operations

Query Builder

  • The state-of-art diagram with zooming and keyboard support
  • Diagram preview and printing
  • Visual addition of sub-queries to any part of the main query
  • Query outline (displayed in Document Outline window)
  • Visual editing of sub-queries
  • Expression builder for creation of complex conditions
  • Copy/Paste for tables on a diagram
  • Undo/Redo support
  • Saving queries to a file
  • Visual building of INSERT, UPDATE, and DELETE statements
  • Conversion of SELECT queries into INSERT statements
  • One-click conversion of SELECT query into UPDATE or DELETE with saving of WHERE condition

Query Profiler

  • SHOW PROFILE, EXPLAIN results and STATUS variables displayed in a UI
  • Query plan is displayed in tree view for easy review
  • Profiling history that can be saved for further analysis
  • Profiling results comparison with highlighted differences
  • Compare profiling results feature with differences highlight
  • Profiling results printing

SQL Editing and Execution

  • Automatic SQL syntax check
  • Context-sensitive code completion
  • Document Outline window for quick navigation through large scripts
  • Execution of scripts, selected SQL fragments, and statements
  • Quick information about schema objects
  • SQL editor with syntax coloring, bookmarks, and text searching
  • SQL formatting on-the-fly in the editor
  • Executed SQL history window for the document
  • Wizard for batch SQL formatting of files on the disk
  • Query execution pane

User Interface

  • Rich user settings
  • UI skins
  • Customizable window layout
  • Tool windows with 'auto-hide' and 'float' modes
  • Multiple shortcut schemes with full shortcut customization
  • Syntax highlight customization
  • Tabbed groups for documents
  • Toolbars customization
  • Ability to browse schema objects in a single editor (pin document option)
  • Windows connection coloring
  • Restoring document tabs from the last session
  • Switching between wizard window and primary window