Database Querying and Management
-
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 → -
SQL Formatting
Configure SQL code formatting in DBCode using VS Code settings or .sql-formatter.json files for consistent code style across your projects.
Learn more → -
Query Parameters
Use query parameters for reusable queries and dynamic database operations.
Learn more → -
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 → -
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 → -
Transaction Control
Manage database transactions with auto-commit control, allowing you to group multiple queries and commit or rollback changes as needed.
Learn more → -
History
History automatically logs executed SQL queries, allowing you to review, reuse, and manage past queries with ease.
Learn more → -
History Sync & Backup
Sync your query history across devices with end-to-end encryption of uploaded data and automatic cloud backup.
Learn more → -
Execution Plans
Understand and optimize queries with database-native EXPLAIN/ANALYZE and the interactive Plan Explorer in DBCode.
Learn more → -
Scratch Files
Persistent SQL scratch files that save your work to disk instead of using untitled files, with automatic organization and cleanup.
Learn more → -
Favorites
Save your frequently used database objects, SQL queries, and files for quick access.
Learn more →