When comparing Squirrel SQL vs SQLGate, the Slant community recommends Squirrel SQL for most people. In the question“What are the best SQL Clients for Windows?” Squirrel SQL is ranked 5th while SQLGate is ranked 8th. The most important reason people chose Squirrel SQL is:
Available for Windows and Mac as well.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Cross-platform
Available for Windows and Mac as well.
Pro Can be extended through plugins
Pro Quick data analysis
Functions; filter, sort and group on grid / Copy, past, sum and statistics functions like excel.
Pro Saves time with autocomplete & template functions
Pro Fast processing and easy customization
They put out weekly updates, so there are new and impressive functions being added pretty consistently.
Pro Supports cloud-based DB such as AWS & Azure
Pro Includes PL/SQL editor and debugger
Pro ER diagrams
Entity Relationship database diagrams limitations are: only supports reverse engineering, and can not export to formats other than .erd
Cons
Con Plugin directory is empty by default
Squirrel does not support major databases out-of-the-box, you have to download and install the JDBC drivers for common major databases.
Con Logon
The logon process after starting up the application is rather long winded (tested with PostgreSQL, no defaults shown for e.g. port number).
Con Free version is limited
e.g. only 10 tables allowed in ERD designer.