Experience the art of coding.
A modern PL/SQL IDE. Exadata and 19c-ready. Just performant.
database management software

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.
SQLDetective CONQUEST
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.
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.

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.
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.
And more

  • Extract DDL for multiple objects directly into the code editor
  • Exclude system database objects from Call Trees
  • Easily switch between Oracle Homes in the redesigned DB Connection window
  • Instantly connect to a database from the startup window

Even more details on the release are available in SQLDetective 5.1.1.361 Release Notes ⟩

Published date: September 23, 2020
Documentation
See the manuals, instructions and whitepapers.
1
SYSTEM REQUIREMENTS: WORKSTATION
free space
200 MB free space
Microsoft Windows
Microsoft Windows 7 and above
Browsers
IE 9.0+, Firefox, Chrome
Privileges
administrator privileges
Redistributable Packages
Microsoft .Net Framework 4.0+, Visual C++ 2008 and 2015, 2017 or 2019 Redistributable Packages (installed along with the app)
2
SYSTEM REQUIREMENTS: ORACLE ENVIRONMENT
Oracle Client
32-bit Oracle Client 9+
Oracle Database
Oracle Database 9i-19c