Best On-Premises SQL IDEs

DBeaver Community is a free, open-source database management tool recommended for personal projects. Manage and explore SQL databases like MySQL, MariaDB, PostgreSQL, SQLite, Apache Family, and more. Connect to popular SQL databases (PostgreSQL, MySQL, SQL Server, Oracle, SQLite, etc.) SQL editor to create queries with syntax highlighting and autocompletion AI assistant in SQL for building queries through natural language SSL/TLS support for encrypted connections SSH tunneling for secure remote access Proxy configuration to work with databases behind a corporate firewall Session Manager to terminate, disconnect, view and search for sessions Lock Manager to monitor and manage database locks Entity Relationship Diagrams to interactively explore and visualize database structure Query manager to view all executed queries, including execution time, duration, affected rows, and errors. Data editor to view, edit, and filter data

Navicat Premium is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud and MongoDB Atlas. You can quickly and easily build, manage and maintain your databases. Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across various DBMS. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.

Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle. Run your sql and sql scripts, manage users, create and edit objects, import data to new or existing tables, diagnose performance issues, visualize your schemas, and much more. The power of your favorite desktop tool, in your browser. Available with Oracle REST Data Services for your on-premises instances. Migrate Oracle On-Premises to Oracle Cloud. Click, browse, and managed the contents of your Oracle Database.