This extension allows you to connect directly to your Firebird® databases, list tables and fields, run queries, display/export results and more.
You can add new connection to your Firebird database by clicking the Add New Connection icon in the DB Explorer title bar. You will be presented with a Connection Wizard to guide you through the process. After the process is complete, your database connection will appear inside DB Explorer View
You can view the database structure by expaning it's tree inside DB Explorer View.
Tip: Right-clicking the tree nodes will give you the list of predefined custom queries.
Before running your queries, remember to set an active database! You can:
Tip: The New Query command sets the selected database active and creates new SQL document.
Execute your SQL query by pressing Ctrl+Alt+Q
or by right-clicking the editor and selecting the Run Firebird Query command.
The results will be displayed in new tab.
Important: Multiple queries are currently not supported. If you have multiple queries written in your SQL document, make the selection around the one you want to run, otherwise you'll get an error.
See here for more details.
firebird.codeCompletion.keywords: <boolean>
| Enable Code Completion for Firebird Reserved Words (Default true)firebird.codeCompletion.database: <boolean>
| Enable Code Completion for Table and Field names (Default true)firebird.logLevel: <string>
| Logging level displayed in output channel. (Default INFO)firebird.maxTablesCount: <number>
| Number of tables visible in database tree. (Default 10)firebird.recordsPerPage: <string>
| Number of records to display per page. (Default 10)firebird.mockarooApiKey <string>
| API key for Mock Data Generator (Default blank)This extensions is still in the early development stage, and as such it may not be suitable for usage in active development environment.
You can submit a bug report or a feature suggestion via GitHub Issue Tracker.