SQL IDEs Benchmark and Key Features

NameWebsiteTool categoryDeploymentPriceFeaturesCollaborationReportingSystem availabilityDatabases connections
Count
SQL notebook
SaaS
$29/user/month
Query referencingQuery parametersDrag and drop queryAutocompleteError highlightingCSV downloads
Version controlShare query/project linkComment
Visualization
Any
BigQuerySnowflakePostgreSQLRedshiftMySQLSQL serverAzure Synapse
PopSQL
Modern editorSQL notebook
SaaS
From $199/month
VisualizationSchema annotationTable popularitySearchAutocompleteError highlightingQuery correctionMulti-platformQuery parameters
Share query/project linkSlack integrationCommentVersion controlQuery library
VisualizationDashboardsScheduled queries
Any
SnowflakeRedshiftBigQueryPostgreSQLSQL serverPrestoPanoplyOracleCassandraSQLiteMongoDBClickhouseAmazon Athena
Hyperquery
Modern editor
SaaS
Datagrip
Modern editor
SaaS
From $199/user/year
SearchAutocompleteQuery correctionQuery parametersDiff viewerMulti-platform
Version control
LinuxAnyMacOs
PostgreSQLBigQuerySnowflakeRedshiftSQL serverSQLiteMongoDB+ 14 others
Aginity
Modern editor
open-sourceOn-premises
From $150/user/year
Query referencingSearchMulti-platformCSV downloadsrecent queries accessObject explorerMultiple-query executionAutocompleteExplain planSave queriesData uploadExcel download
Query libraryVersion control
VisualizationScheduled queries
Any
SnowflakePostgreSQLRedshiftSQL serverIBM Db2IBM NetezzaTanzu GreenplumAzure SynapseApache SparksApache HiveAmazon RDSAmazon Aurora
Hex
SQL notebookPython notebook
SaaS
Contact only
AutocompleteQuery parameters
Version controlReal-time multiplayerCommentShare query/project link
VisualizationDashboardsReports
Any
SnowflakeBigQueryRedshiftPostgreSQLMySQL
Noteable
SaaS
Query.me
SQL notebook
SaaS
Contact only
Query parametersAutocompleteFrequently used queriesQuery referencingSearch
Share query/project linkReal-time multiplayerCommentSlack integration
Scheduled queriesVisualization
Any
SnowflakeRedshiftBigQueryPostgreSQLMicrosoft SQL ServerMore
Adminer
Standard IDE
On premises
Contact only
AutocompleteDatabase administration
MariaDBMySQLPostgreSQLSQLiteOracleMongoDBSimpleDB
Valentina Studio
Standard IDE
On premises
Free
AutocompleteSyntax highlightingrecent queries accessSave queries
Any
ValentinaDBMySQLMariaDBSQLitePostgreSQL
HeidiSQL
Standard IDE
open-source
Free
Syntax highlighting
Windows
MariaDBMySQLPostgreSQLSQLite
DBeaver
Standard IDE
open-source
Free
ER diagramsAutocompleteMulti-platform
WindowsMacOsLinuxEclipse plugin
MariaDBMySQLPostgreSQLSQLiteOracleMore
RazorSQL
Standard IDE
On premises
From $92/user
Syntax highlightingAutocompleteMultiple-query execution
Scheduled queries
MacOsLinuxWindowsSolaris
40+ Databases
Toad for SQL Server
Database administration
SQuirrel SQL
Standard IDE
open-source
Free
AutocompleteSyntax highlightingcopy-paste
Microsoft SQL Server Management Studio Express
Standard IDE
Free
Integrated script editorObject explorerActivity monitor
Windows
Oracle SQL Developer
Standard IDE
Free
Version control
Any
Datapine SQL Editor
Standard IDE
SaaS
From $257/month
Drag and drop queryAutocomplete
Any
MySQLPostgreSQLMariaDBOracle
My SQL Workbench
Standard IDE
Preview changes before applyingSyntax highlightingAutocomplete
WindowsMacOsLinux
SQLgate
Standard IDE
On premises
From $300/month
Autocomplete
Any