Our go-to database tool.
Use Cases and Deployment Scope
We’re a digital marketing agency with a large data warehouse that uses multiple databases, and we interact with many database types and integrations for our own needs as well as those of our clients. DbVisualizer makes this very simple with easy integrations to every type of database we’ve needed to connect to, with a fantastic UI that makes working across databases easy and all in one spot.
Pros
- Out-of-the-box support for many different databases.
- Intuitive UI for interacting with data.
- Flexibility of SQL Commander for writing scripts.
- Great support for working with JSON data in recent updates.
- Database connections over SSH.
- Table relationship visualization is very helpful.
- The tree view is well organized in how it splits out schemas.
Cons
- Would be great if we could update individual JSONB properties directly in the JSON viewer window.
- Sometimes, when a table structure is changed (e.g., adding columns), the changes are not reflected when viewing the table because the old structure is still cached.
Return on Investment
- Faster access to more typically “web-based” data, like BigQuery, for more rapid prototyping and exploration.
- Parameterized queries in SQL Commander have become our go-to for getting fast answers to common questions about our data.
Usability
Alternatives Considered
SQL Server Management Studio (SSMS)
Other Software Used
Google BigQuery, PostgreSQL, Apache Hadoop, MySQL, Db2
