Best SQL IDEs in Germany

DbVisualizer is one of the world's most popular database editors. With almost 7 million downloads and Pro users in 150 countries worldwide, it won't disappoint you. Free and Pro versions are available. Developers, analysts, and DBAs use it to elevate their SQL experience with modern tools to visualize and manage their databases, schemas, objects, and table data, auto-generate, write, and optimize queries, and so much more. It connects to all popular databases, such as MySQL, PostgreSQL, SQL Server, Oracle, Cassandra, Snowflake, SQLite, BigQuery, and 30+ others, and runs on all popular OSes (Windows, macOS, and Linux). A powerful SQL editor with intelligent autocomplete, visual query builders, variables, and more. You can fully control window layouts, key bindings, UI theme, mark scripts, and database objects as favorites for quick access or even work outside of DbVisualizer. DbVisualizer is also built to meet rigorous security standards, all configurable within the product.

datapine’s business intelligence and dashboard software helps people to turn data into actionable insights and make data-driven decisions in real-time. A user-friendly drag & drop interface empowers managers to data scientists to visualize and analyze complex data by asking important business questions and receiving answers immediately. It offers a wealth of innovative analytics features like predictive analytics and dynamic, interactive business dashboards for modern, KPI driven businesses. Dozens of fast and easy data connectors to all common data sources (databases, flat files, social media, marketing analytics, CRM, ERP, helpdesk etc.) and a wealth of pre-build dashboard templates for different business functions (marketing, sales, management, HR etc.), industries (retail, logistics, healthcare, market research etc.) and platforms (Google Analytics, Facebook, Twitter, Zendesk etc.) help new users to get started quickly. datapine is a RIB Software GmbH solution.

Meet DataGrip, our new database IDE that is tailored to suit the specific needs of professional SQL developers. Allows you to execute queries in different modes and provides a local history that keeps track of all your activity and protects you from losing your work. Lets you jump to any table, view, or procedure by its name via the corresponding action, or directly from its usages in the SQL code. Gives you an extended insight into how your queries work and into the database engine behavior, so you can make your queries more efficient. DataGrip provides context-sensitive code completion, helping you to write SQL code faster. Completion is aware of the tables structure, foreign keys, and even database objects created in code you're editing. DataGrip detects probable bugs in your code and suggests the best options to fix them on the fly. It will immediately let you know about unresolved objects, using keywords as identifiers and always offers a way to fix the problems.

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

SQLGate is a simple but powerful IDE for multiple SQL databases. As an integrated database management and development solution, it simplifies the construction and operation of databases. It is customized for seven different databases that make up 83.2% of the DBMS market. These include Oracle, SQL Server, MySQL, MariaDB, Tibero, and PostgreSQL. SQLGate makes it easier and quicker to deal with databases holding large amounts of data. Multiple Languages available: Korean, English, Spanish, French, Japanese, etc..

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.

Aqua Data Studio is a multiple-platform, integrated development environment (IDE) for data. It provides benefits to a variety of data-centric roles, allowing them to manage a wide range of data sources. Aqua Data Studio provides scalable, cross-platform data management, supporting IT and data-centric specialists, including developers, database administrators, as well as data analysts, data modelers, and data architects. Simplifies tedious tasks involving SQL queries, data, result sets, schema, data models, files, instances, servers, as well as automation. Aqua Data Studio can be installed on the three popular operating systems: Microsoft Windows, Apple macOS, and Linux. The graphical user interface can display the nine of the most widely spoken languages: English, Spanish, French, German, Korean, Portuguese, Japanese, and Chinese. Aqua Data Studio supports over 40 of the most popular data source platforms, including relational, NoSQL, as well as managed cloud data source

Modern, native client with intuitive GUI tools to create, access, query & edit multiple databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, Cassandra, Snowflake, Oracle, Redis.

Write and execute queries in a fully interactive SQL editor. JackDB has everything you'd want in a database client, including: syntax highlighting, code formatting, and intelligent autocompletion. Snippets allow your most useful SQL queries to be saved and shared. Simply write and save any query in JackDB, and share the snippet publicly with your team. Whenever anyone updates a snippet, everyone gets access to its latest version. Security is our highest priority at JackDB. Roles are a very convenient and secure way to restrict database access to authorized users and provision new users with access to data sources. Explore everything in your database, not just tables and views. View your indexes, schemas, and other important system details such as tablespaces and user sessions.

Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development. From writing simple SQL queries to developing complex databases, Navicat for PostgreSQL is designed to accommodate a wide range of users, from PostgreSQL beginners to seasoned developers. Connect to local/remote PostgreSQL servers and compatible with cloud databases like Amazon Redshift, Amazon Aurora, Amazon RDS, Google Cloud and Microsoft Azure, and all PostgreSQL database objects. Navicat provides users with our Navicat Cloud service. Sync your connection settings and queries to the cloud so you can get real-time queries and connections anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Navicat allows you to establish secure SSH sessions through SSH Tunneling, ensuring strong authentication and secure encryption between two hosts. The authentication method can use a password or a public/private key pair.

Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE. Design business reports running in Valentina Studio Pro, on Valentina Server or in an application with an Application Developer Kit. Backward Engineering in Standard with forwarding Engineering in Valentina Studio Pro. Reverse engineering and create diagrams for existing databases. Add new objects to diagrams. Write SQL queries with auto-completion, color syntax. Define, manage, save favorite queries; access recent queries. Function browser dictionary of each function. Consoles for errors, warnings, and performance. Search, Export result records into CSV, JSON, Excel. Edit properties of multiple objects at the same time. Drill down to tables and fields; incredible fast searching. Reverse engineering and create diagrams for existing databases. Add new objects to diagrams. Add/drop users, and groups, and manage privileges.

Count is a fully collaborative and reactive data whiteboard. It brings together all the flexibility and creativity of a whiteboard, with the power of a SQL IDE, and the reactivity of BI notebooks. It makes it easy to break apart complex SQL queries and data models into interconnected cells to better understand the logic. Add sticky notes and visuals to help explain your work to stakeholders. Collaborate with other analysts or stakeholders as you build so you can get feedback faster. Turn any canvas into an interactive report or slideshow presentation.

SQL Connect is a desktop-based SQL development tool designed for Oracle Cloud applications, offering a comprehensive suite of features for efficient data querying and management. It provides real-time access to Oracle ERP, SCM, and HCM Pods, enabling users to execute ad-hoc SQL queries, browse database objects, and export results to CSV or Excel formats. It supports background query execution, allowing long-running queries to be processed without interrupting the user's workflow. Additionally, SQL Connect includes IntelliSense for code completion, a SQL Minimap for script navigation, and Git integration for version control and collaborative development. It is secured by Oracle Cloud Role access. It caters to individual users, contractors, developers, consultants, and Oracle Cloud experts seeking a robust SQL IDE for Oracle Cloud environments.

CloudBeaver Enterprise is a lightweight, browser-based data management platform designed for secure, multi-source database operations. It enables seamless integration with SQL, NoSQL, and cloud databases, including AWS, Microsoft Azure, and Google Cloud Platform (GCP), through its cloud explorer feature. It supports a range of functionalities such as data visualization, SQL script execution with smart autocompletion, entity-relationship diagramming, and AI-assisted query generation. Deployment is simplified via a single Docker command, and the system supports offline server installations without requiring internet access. Advanced user management capabilities include integration with enterprise authentication systems like AWS SSO, SAML, and OpenID, allowing for secure access control and user provisioning. CloudBeaver Enterprise also facilitates collaboration among teams by enabling shared access to resources and connections.