Azure Data Studio

SQL Operations Studio facilitates cross-platform database development and management in a user-friendly working environment, ensuring compatibility with SQL Server, Azure SQL Data Warehouse and Azure SQL Database. Designed mainly for non-professional database administrators, this application makes it easy to perform routine maintenance operations on a supported database.

Connecting to a server is not complicated, as you simply have to fill in a form with the correct data. Once connected, you will be able to browse the database schema in a tree view, manage databases and server objects, and configure specific parameters of the server.

SQL Operations Studio can create server groups in case you need more connections. It allows you to perform database backups periodically to make sure the stored data is safe.

SQL Operations Studio enables you to write custom SQL queries using its built-in editor and thus create databases and tables, or run queries against the database to retrieve tuples. Each new query opens in a separate tab, and the editor fully supports syntax highlighting for the SQL language. It comes equipped with line numbering and keyword suggestions, making it easy to type in the code.

Additional features of the query editor include error diagnostics, peek definitions and integrated tooltips. The result viewer is capable of displaying large data sets in grid view, with charting and exporting options. What's more, you can manage table contents by inserting or updating rows or deleting tuples.

You can view the history of the executed operations in the Task History of SQL Operations Studio, which also reveals errors if any.

SQL Operations Studio delivers a powerful database management and maintenance tool, with full Git integration and script execution support. A built-in terminal and fully customizable settings are among the features that have not been mentioned above. The rest is for you to discover while trying out the application.