Command Palette Reference

This reference guide covers all default keyboard shortcuts and commands available in Coginiti's Command Palette. These keybindings can be customized by users to match their preferred workflow and development environment.

Overview

Coginiti's Command Palette provides comprehensive keyboard shortcuts for efficient interaction with the application. The shortcuts are organized by functional areas and designed for productivity across different platforms.

Platform Key Mapping

• Mod Key: Ctrl on Windows/Linux, Cmd on macOS
• Alt Key: Alt on Windows/Linux, Option on macOS
• Context-Sensitive: Some shortcuts only work in specific areas or when certain elements are focused

Accessing the Command Palette

• Primary Access: Mod+Shift+P - Open Command Palette
• Keybindings Help: F1 (App) / Mod+F1 (Web) - Open Keybindings Popup

SQL Workbench Commands

Query Execution

Execute SQL queries and scripts with various execution modes:

Shortcut	Command	Description
Mod+Enter	Run Script or Selected Code	Execute the current script or selected text
F5	Run Script at Cursor Position	Execute query at current cursor location
Mod+F5	Run Script as Batch	Execute script in batch mode
Shift+F5	Run Script as Sequence	Execute script statements sequentially
Shift+F8	Explain Plan	Generate and display query execution plan

Execution Modes Explained

Run Script or Selected Code (Mod+Enter):

• Executes selected text if text is selected
• Executes entire script if no selection
• Most commonly used execution command

Run Script at Cursor Position (F5):

• Executes the statement at current cursor position
• Useful for executing specific statements in multi-query files
• Automatically detects statement boundaries

Run Script as Batch (Mod+F5):

• Executes all statements as a single batch
• Faster for multiple related statements
• Transactions are handled as a unit

Run Script as Sequence (Shift+F5):

• Executes statements one by one in order
• Allows for individual statement result inspection
• Better error isolation and debugging

Explain Plan (Shift+F8):

• Generates query execution plan without running the query
• Shows optimizer decisions and performance characteristics
• Essential for query performance analysis

Query Analysis

Shortcut	Command	Description
Mod+Alt+E	Explain Query	AI-powered query explanation
Mod+Alt+O	Optimize Query	AI-powered query optimization suggestions
Ctrl+Alt+E	Explain Plan: Toggle View	Switch between plan views

File Operations

Basic File Management

Shortcut	Command	Description
Mod+S	Save File/Catalog Entry	Save current file or catalog item
Mod+Shift+S	Save As	Save file with new name or location
Mod+Shift+O	Open File	Open file dialog to load existing file

File Operation Details

Save File (Mod+S):

• Saves current active file or catalog entry
• Works for SQL files, CoginitiScript, and other editable content
• Automatic backup creation (if enabled in settings)

Save As (Mod+Shift+S):

• Creates copy of current file with new name
• Allows saving to different locations
• Preserves original file unchanged

Open File (Mod+Shift+O):

• Opens file browser dialog
• Supports multiple file format filters
• Recent files quick access

Catalog Management

Data Catalog Operations

Shortcut	Platform	Command	Description
Mod+Shift+E	App	Export Popup	Open export dialog for catalog items
Alt+Shift+E	Web	Export Popup	Open export dialog for catalog items
Mod+Shift+I	App	Import Popup	Open import dialog for catalog items
Alt+Shift+I	Web	Import Popup	Open import dialog for catalog items
F9	All	Show Lineage in Editor	Display data lineage visualization

Catalog Features

Export Functionality:

• Export queries, results, and metadata
• Multiple format support (SQL, CSV, JSON)
• Batch export capabilities for multiple items

Import Functionality:

• Import SQL files, query libraries, and configurations
• Support for various file formats and sources
• Bulk import with validation and conflict resolution

Data Lineage (F9):

• Visualizes data flow and dependencies
• Shows table relationships and query connections
• Interactive lineage exploration and navigation

Code Editor

Basic Editing Operations

Shortcut	Command	Description
Mod+A	Select All	Select all text in current editor
Mod+C	Copy	Copy selected text to clipboard
Mod+X	Cut	Cut selected text to clipboard
Mod+V	Paste	Paste text from clipboard
Mod+Z	Undo	Undo last action
Mod+Y	Redo	Redo previously undone action

Advanced Editing Operations

Shortcut	Command	Description
Alt+Mod+Up	Add Cursor Above	Add additional cursor one line above
Alt+Mod+Down	Add Cursor Below	Add additional cursor one line below
Alt+Right	Move Cursor Next Word Right	Jump cursor to next word boundary
Alt+Left	Move Cursor Next Word Left	Jump cursor to previous word boundary
Mod+Right	Move Cursor to Line End	Move cursor to end of current line
Mod+Left	Move Cursor to Line Start	Move cursor to beginning of current line
Alt+Shift+I	Add Cursors to Line Ends	Add cursor at end of each selected line
Mod+D	Selection to Next Find Match	Extend selection to next matching occurrence

Multi-Cursor Editing

Benefits of Multi-Cursor Operations:

• Edit multiple locations simultaneously
• Bulk find and replace operations
• Consistent formatting across multiple lines
• Efficient code refactoring

Common Multi-Cursor Workflows:

1. Column Editing: Use Alt+Mod+Up/Down to create vertical cursor column
2. Word Selection: Use Mod+D to select multiple instances of same word
3. Line Endings: Use Alt+Shift+I to add cursors to selected line endings

Line Operations

Shortcut	Command	Description
Alt+Shift+Down	Copy Line Down	Duplicate current line below
Alt+Shift+Up	Copy Line Up	Duplicate current line above
Alt+Down	Move Line Down	Move current line down one position
Alt+Up	Move Line Up	Move current line up one position
Shift+Mod+K	Delete Line	Delete entire current line
Shift+Enter	Insert Line Below	Create new line below cursor
Shift+Mod+Enter	Insert Line Above	Create new line above cursor

Line Manipulation Best Practices

Code Organization:

• Use line duplication for template creation
• Move related lines together for better readability
• Insert strategic blank lines for code structure

Refactoring Workflows:

• Duplicate lines before modification for comparison
• Move lines to reorganize code logic
• Delete redundant or commented-out code

Code Formatting

Shortcut	Command	Description
Alt+Shift+F	Format Document	Format entire document according to style rules
Mod+Alt+S	Format Selection	Format only selected code portion
Mod+]	Indent Line	Increase indentation of current line
Mod+[	Outdent Line	Decrease indentation of current line
Mod+/	Toggle Line Comment	Add/remove line comment markers
Alt+Shift+A	Block Comment	Add/remove block comment markers

Formatting Configuration

Document Formatting (Alt+Shift+F):

• Applies consistent indentation and spacing
• Follows configured SQL style guidelines
• Formats entire file at once

Selection Formatting (Mod+Alt+S):

• Formats only selected text
• Preserves surrounding code formatting
• Useful for partial cleanup operations

Comment Management:

• Line comments (--) for single line comments
• Block comments (/* */) for multi-line comments
• Toggle functionality for easy comment/uncomment

Search & Replace

Shortcut	Command	Description
Mod+F	Find	Open find dialog for text search
Enter	Find Next	Jump to next search result (when search focused)
Shift+Mod+G	Find Previous	Jump to previous search result
Alt+Mod+F	Replace	Open find and replace dialog

Search Features

Find Operations:

• Case-sensitive and case-insensitive search
• Regular expression support for complex patterns
• Whole word matching for precise searches

Replace Operations:

• Single replacement confirmation
• Replace all occurrences at once
• Regex-based replacements with capture groups

Code Folding

Shortcut	Command	Description
Alt+Mod+[	Fold	Collapse current code block
Alt+Mod+]	Unfold Recursively	Expand current code block and nested blocks
Mod+Alt+0	Fold All	Collapse all foldable code blocks
Mod+Alt+J	Unfold All	Expand all folded code blocks
Mod+Alt+9	Unfold All Regions	Expand all folded regions

Code Folding Benefits

Navigation Efficiency:

• Focus on specific code sections
• Reduce visual clutter in large files
• Quick overview of code structure

Code Review:

• Collapse irrelevant sections during review
• Focus on changed or problematic areas
• Maintain context while examining details

Code Intelligence

Shortcut	Command	Description
Ctrl+Space	Trigger Suggest	Open IntelliSense suggestions
Mod+.	Quick Fix	Show available quick fixes
Alt+Mod+.	Auto Fix	Apply automatic fixes
Mod+F2	Change All Occurrences	Rename all instances of symbol
Alt+G	Go to Line	Jump to specific line number

IntelliSense Features

Auto-Completion:

• SQL keyword completion
• Table and column name suggestions
• Function parameter hints
• CoginitiScript macro completion

Quick Fixes:

• Syntax error corrections
• Code style improvements
• Performance optimization suggestions
• Import statement additions

Text Deletion

Shortcut	Command	Description
Mod+Backspace	Delete All Left	Delete from cursor to beginning of line
Ctrl+K	Delete All Right	Delete from cursor to end of line
Backspace	Delete	Delete character before cursor
Del	Forward Delete	Delete character after cursor

Workspace Management

Tab Management

Shortcut	Command	Description
Alt+T	Create New Tab	Open new editor tab
Alt+W	Close Current Tab	Close active tab
Mod+Alt+T	Restore Closed Tab	Reopen recently closed tab
Mod+Alt+Right	Next Tab	Switch to next tab
Mod+Alt+Left	Previous Tab	Switch to previous tab

Tab Organization

Tab Navigation:

• Efficient switching between multiple queries
• Keyboard-only tab management
• Recently closed tab restoration

Workspace Organization:

• Group related queries in separate tabs
• Use tab titles for easy identification
• Maintain clean workspace with tab management

Results & Execution Management

Shortcut	Platform	Command	Description
Alt+6	Browser/Windows	Toggle Results Pane	Show/hide query results panel
Mod+6	macOS	Toggle Results Pane	Show/hide query results panel
Mod+Up	All	Next Results Tab	Switch to next results tab
Mod+Down	All	Previous Results Tab	Switch to previous results tab
Ctrl+\	All	Navigate to Error	Jump to error location in code

Results Navigation

Results Panel Management:

• Toggle visibility for more editor space
• Navigate between multiple result sets
• Quick error location identification

Multi-Query Results:

• Switch between results from different queries
• Compare results across multiple executions
• Maintain result history for reference

Database Explorer

Database Navigation

Shortcut	Context	Command	Description
Space	DB Explorer focused	Copy Name to Editor	Copy selected object name to editor
Mod+Enter	DB Explorer focused	Open in Tab	Open selected object in new tab

Database Object Interaction

Object Name Copying:

• Quick insertion of table/column names
• Maintain proper SQL syntax and quoting
• Reduce typing errors and improve efficiency

Object Exploration:

• Open table definitions in new tabs
• View object properties and metadata
• Navigate database schema efficiently

AI Assistant

AI-Powered Features

Shortcut	Command	Description
Mod+Enter	Send Message	Send message in AI chat interface
Mod+Alt+E	Explain Query	Get AI explanation of selected query
Mod+Alt+O	Optimize Query	Get AI optimization suggestions
Mod+Shift+Z	Cancel Request	Cancel current AI request

AI Integration Benefits

Query Understanding:

• Natural language explanations of complex queries
• Business logic interpretation
• Performance characteristic analysis

Query Optimization:

• AI-powered performance improvement suggestions
• Index recommendation analysis
• Query rewriting for better performance

Interactive Assistance:

• Conversational query development
• Problem-solving support
• Learning and skill development

Navigation & UI

Interface Management

Shortcut	Platform	Command	Description
Mod+Shift+P	All	Open Command Palette	Access all available commands
F1	App	Open Keybindings Popup	Display keyboard shortcut reference
Mod+F1	Web	Open Keybindings Popup	Display keyboard shortcut reference
Alt+O	Browser/Windows	Edit Connections	Open connection management dialog
Mod+O	macOS	Edit Connections	Open connection management dialog

Interface Customization

Command Palette:

• Search and execute any available command
• Discover new features and shortcuts
• Quick access to less common operations

Connection Management:

• Rapid access to database connections
• Switch between different environments
• Manage connection templates and settings

Utility Operations

Text Processing

Shortcut	Command	Description
Mod+Alt+X	Trim Trailing Whitespace	Remove whitespace at end of lines

Code Maintenance

Whitespace Management:

• Clean up code formatting inconsistencies
• Prepare code for version control
• Maintain consistent code style standards

Customizing Keyboard Shortcuts

Accessing Keybinding Settings

1. Open Command Palette: Mod+Shift+P
2. Search for "Keybindings" or "Keyboard Shortcuts"
3. Select keybinding configuration option
4. Modify shortcuts according to your preferences

Customization Options

Personal Preference Customization

• Modifier Key Preferences: Adjust Mod, Alt, Shift combinations
• Function Key Usage: Enable/disable function key shortcuts
• Context-Specific Shortcuts: Customize shortcuts for specific editors or panels

Team Standardization

• Export keybinding configurations for team sharing
• Import standard configurations for consistency
• Document custom shortcuts for team reference

Best Practices for Customization

Workflow Optimization

• Identify frequently used commands and assign convenient shortcuts
• Group related commands with similar key combinations
• Avoid conflicts with system-level shortcuts

Muscle Memory Development

• Start with default shortcuts and gradually customize
• Practice new shortcuts consistently for memorization
• Document changes for reference and training

Platform-Specific Considerations

Windows/Linux Shortcuts

• Ctrl key serves as primary modifier
• Alt key for secondary modifications
• Function keys widely available and customizable

macOS Shortcuts

• Cmd key serves as primary modifier (Mod)
• Option key replaces Alt in most combinations
• Function key behavior may require Fn key activation

Web Browser Considerations

• Browser shortcuts may conflict with application shortcuts
• Full-screen mode recommended for optimal experience
• Browser-specific limitations on certain key combinations

Troubleshooting Shortcuts

Common Issues

Shortcuts Not Working

Possible Causes:

• Browser capturing key combinations
• Conflicting extensions or applications
• Focus not on correct interface element
• Platform-specific key mapping issues

Solutions:

1. Verify focus: Ensure cursor is in correct editor or panel
2. Check browser settings: Disable conflicting browser shortcuts
3. Review extensions: Temporarily disable browser extensions
4. Reset keybindings: Restore default shortcuts if customizations cause issues

Platform Compatibility

Cross-Platform Development:

• Document platform differences in team environments
• Test shortcuts on all target platforms
• Provide platform-specific guidance for users

Performance Considerations

Shortcut Response Time

• Complex operations may have slight delays
• Network-dependent commands (AI features) may take longer
• Large file operations may temporarily block shortcuts

Memory and Resource Usage

• Multiple tabs and results may impact shortcut responsiveness
• Close unused tabs to maintain optimal performance
• Monitor system resources during intensive operations

Summary

Coginiti's Command Palette provides comprehensive keyboard shortcuts for efficient development workflows:

✅ SQL Execution: Multiple execution modes for different query scenarios
✅ Code Editing: Advanced text manipulation and formatting capabilities
✅ File Management: Efficient file operations and catalog management
✅ Workspace Organization: Tab management and results navigation
✅ AI Integration: Keyboard access to AI-powered features
✅ Customization: Full keybinding customization for personal workflows

Master these shortcuts to significantly improve your productivity and development efficiency in Coginiti. Regular practice and gradual adoption of new shortcuts will enhance your overall experience and workflow speed.