DuckDB SQLTools vscode extension v1.0.0 Preview release

[RandomFractals]

🥳 Happy to announce the first release of DuckDB SQLTools for VSCode and VSCodium users.

DuckDB SQL Tools extension adds DuckDB support to VSCode IDE, and provides database schema and SQL query API and user interfaces for the popular SQLTools extension, SQL query editor, SQL language server, and data processing tools.

Features

DuckDB SQL Tools extension adds the following capabilities to VSCode IDE for working with DuckDB instances:

• Connect to a local DuckDB instance
• Create new in-memory DuckDB instance
• View DuckDB tables, columns, and views
• Run SQL queries on open DuckDB connections
• Attach SQLite database files to in-memory DuckDB instances
• Query remote CSV and Parquet data files with DuckDB HTTPFS extension
• Create in-memory DuckDB tables from remote data sources and query results
• Manage DuckDB connections in SQLTools Database Explorer
• Autocomplete SQL keywords, table names, column names, and view names on open database connections in VSCode SQL editor
• Save named SQL query Bookmarks
• Use SQL Query History
• Export SQL query results in CSV and JSON data formats

See SQLTools documentation for a comprehensive list of SQLTools extension features contributed to VSCode IDE.

Installation

Install DuckDB SQL Tools extension from VSCode marketplace in your browser by clicking on Install button in the extension info page header.

Alternatively, you can install this extension directly in VSCode IDE from Extensions tab (ctrl+shift+x) by searching for DuckDB.

Users of VSCodium and other VSCode-based IDEs can install DuckDB SQL Tools extension using .vsix extension package attached to the Assets section in published releases of this extension on Github. Follow install from .vsix instructions in your VSCode extensions compatible IDE or online container service to install it.

Feedback

Use DuckDB SQL Tools Github Discussions portal to submit your feedback, share examples of how you are using this VSCode extension, or request new trivial and premium features. Our aim is to make DuckDB more accessible and easier to use in VSCode IDE and Terminal.

🤗