Data management
Results and comparisons
Results visualization
As the result of a query is displayed you can adjust its format to your needs. You can view the results as simple lists, line charts, staple graphs, plot data in a grid, and much more.
Comparing queries
When you work with complicated queries, you oftentimes find yourself needing to compare one to another. Perhaps a colleague sent you a modified version of your query, or you want to compare an old functioning query to a new one that you are debugging. DbVisualizer will help you by highlighting what code has been added, what has been removed, and what has been adjusted.
Edit like a spreadsheet
Inline and direct editing of data
As you view an object, for example a table in DbVisualizer you can directly start editing the table-data within. A row can also be opened in a form pane displaying the columns and data top-down rather than left-right in the grid. This gives a compact view of the data in a row.
Edit locally, then commit
When data has been added, modified, or removed you will get clear indications of the changes you have made. The changes you have made will only be reflected for you locally until you decide to commit the changes to the database.
Exports
Quick export to spreadsheet
One of the simplest ways to share or analyze data is via spreadsheets. With a simple click, you can open a result set directly in Excel or another spreadsheet software to quickly analyze, modify or share.
Advanced exporting
DbVisualizer gives you the freedom to export a result set in a variety of different files and formats.
You can export your results into CSV, HTML, TXT, SQL, XML, EXCEL, or JSON and decide exactly how you want the data to be formatted.