Database Querying and Management

  1. SQL Editor

    The SQL Editor in DBCode enables you to create, execute, and manage SQL queries within `.sql` files in Visual Studio Code, featuring syntax highlighting, code formatting, intelligent autocomplete, and seamless connection switching.

    Learn more →

  2. Query Parameters

    Use query parameters for reusable queries and dynamic database operations.

    Learn more →

  3. Autocomplete

    Autocomplete simplifies SQL query creation by offering a context menu of intelligent, context-aware suggestions. These include table names, column names, and SQL keywords, helping you write queries faster and more accurately.

    Learn more →

  4. Inline Completion

    Inline Completion uses AI to enhance SQL coding productivity and generate schema aware SQL directly within your editor, enabling you to create complex queries, or ask natural language questions.

    Learn more →

  5. History

    History automatically logs executed SQL queries, allowing you to review, reuse, and manage past queries with ease.

    Learn more →

  6. History Sync & Backup

    Sync your query history across devices with end-to-end encryption of uploaded data and automatic cloud backup.

    Learn more →

  7. Execution Plans

    Understand and optimize queries with database-native EXPLAIN/ANALYZE and the interactive Plan Explorer in DBCode.

    Learn more →

  8. Scratch Files

    Persistent SQL scratch files that save your work to disk instead of using untitled files, with automatic organization and cleanup.

    Learn more →

  9. Favorites

    Save your frequently used database objects, SQL queries, and files for quick access.

    Learn more →