Indulge your productivity.

SQLDetective offers an extensive toolset of over 50 functional modules to help you design, code and maintain your DB faster and smarter.

Crush the code.

SQLDetective supports 59 object types in Oracle Database 19c with their properties, privileges, DDL, dependencies, source code and more.

Intelligent
Wizards and inline assistants take out the routine and give you more time to create and design.
Feature-rIch
Enjoy the code review and improvement tools, interactive visuals, integrated support for Oracle EXADATA and more.
Team-friendly
Rethink how the teamwork looks like with a chat platform integrated into the IDE. It's fast and secure with Telegram-powered chat.

See latest updates

Read release notes

Built around your every need.

DEVELOP SMARTER
Create and change attributes for tables, views, triggers, indices, clusters, collections, jobs and other objects with feature-rich wizards. Avoid common mistakes and code consistently using inline Code Analyzer.
MANAGE EVERYTHING
Pin down those pesky bottlenecks, monitor and adjust database and session performance deep down to low-level parameters.
TEST, TUNE & DEBUG
Use bind and substitution variables in statements and step through the code with a multifunctional debugger. View execution plans and fine-tune conveniently with Explain Plan feature.
ENGAGE BUSINESS
Build an efficient communication with process stakeholders and analysts using interactive flowcharts and diagrams. For tech minds there are extra visual deliverables to build insights, like data flow diagrams and CRUD-matrices.
MASTER THE DATA
Any query is built with ease with a visual Dataset Builder. Popular formats are natively supported, so you can move around scalar and complex data types.
MADE FOR PROs
Tasks are performed faster with the needed tools always at hand. The essential and pro-level functions are logically organized in an adjustable UI. You can even work with several databases at once and switch on the fly.

A great toolset for every role.

SQLDetective is a robust PL/SQL IDE with an exceptional coverage for development-related functional areas.

Developers

Produce performant and maintainable PL/SQL code taking full benefit of Oracle database development and Exadata functionality. Develop faster with wizards and inline assistants. Improve execution plans and resolve bottlenecks with detailed debugger and tracer. Tune the IDE to familiar shortcuts and behaviour in a click.

Architects

Write strong, structured code ensuring corporate standards and integration requirements are met. Troubleshoot DB architecture problems, plan migrations and scale-ups with itemised reports and interactive diagrams. Schedule times for upgrades and repairs with detailed engine statistics.

Professional DBAs

Monitor and manage sessions, tablespaces, data files, rollback segments, users & roles with full support for Oracle RAC. Control object grants, locate top sessions and troubleshoot query performance. Implement your DevOps strategy with ease with a unified tool.

Conquest
→
Products
→
SQLDetective
→
Overview

SQLDetective 5

FEATURE TOUR

Create with ease.

Configure settings for each DB object with its own wizard. Grouped by 59 object types, wizards provide full access to complete object-related configurations and object attributes.

Understand dependencies.

Understand unfamilar PL/SQL and figure out data dependencies with a help of a Data Dependency Analyzer. It represents referring data based on integrity constraints, like primary key, foregin key, and unique key.

User-friendly environment.

SQLDetective features a configurable environment that allows full customization. Use the predefined interface and shortcut settings from one of the classic tools or create those of your own.

Code quality delivered.

Make your code easy to maintain and detect potential errors and inconsistencies early in the development cycle with the extended set of Code Review Rules.

Enjoy a stunning visual experience analyzing objects, workflows and scripts with interactive flowcharts and call tree diagrams, metrics reports and CRUD matrices.

Refined version control.

SQLDetective can track changes for a database, a schema or an object giving you an unprecedented degree of refined control over versioning. Individual changes are highlighted and color-coded making it easy to read differences. To track progress, you can receive automated comparison reports, too.

Migrate smoothly.

Migrate databases using DDL. Extract DDL at the object and schema levels using either Oracle's DBMS_METADATA or SQLDetective's native engine. This ensures that no object of property is left behind during the migration or bulk replication.

Develop for performance.

With the new SQLDetective 5.1 you can now develop specifically for Oracle Exadata — make most of Columnar Compression, Flash Cache and refined access to storage cell specific functionality.

Take your data anywhere.

Export and import scalar and complex data types into many popular enterprise and desktop formats. Browse, search and modify data across massive arrays in a snap.

Conquest
→
Products
→
SQLDetective
→
Feature Tour

SQLDetective 5

Learn about the latest updates for SQLDetective.

Technical debt metrics
Calculate the price of fixing structural and logical imperfections detected by the code analyzer.
DB connections export
Export existing database connections to an XML file in a click and keep them for further reuse.
Oracle Client and Microsoft Package
Automatically check environment for the mandatory configurations and instantly connect to an Oracle DB.