Code Insight & Refactoring
Code Insight
Handy Refactoring Everywhere
Rename aliases, symbols, and table references throughout your SQL script in a single click. Navicat automatically updates every corresponding column, join, and filter, keeping your code clean and preventing broken references.
Context-Aware Code Completion
Get intelligent suggestions for tables, fields, and keywords as you type, with automatic JOIN condition completion based on foreign keys and matching schema names.
Catch Mistakes Live, Fix Them with AI
Catch syntax errors and invalid references as you type, hover for diagnostic details, and click "Fix with AI" to generate and apply corrected code instantly.
Instant Schema Insights on Hover
Inspect schema metadata and view DDL effortlessly just by hovering over any table or field. Use interactive breadcrumbs to trace database paths, locate objects in the navigation tree, or launch object designers and viewers in a single click.
Trace Symbols Across Your Script
Click any identifier or alias to spotlight every place it appears in your query, making complex logic and multi-table joins easy to track.
Jump Straight to Declarations
Press Ctrl and click any table or field name to jump directly to its designer or data editor, or instantly locate and highlight the object in your navigation pane.
