{"repo":"evidence-dev/sqltools-duckdb-driver","free":true,"listed":false,"github":"https://github.com/evidence-dev/sqltools-duckdb-driver","clone":"git clone https://github.com/evidence-dev/sqltools-duckdb-driver.git","description":"DuckDB Driver for SQLTools","language":"TypeScript","stars":29,"topics":["duckdb","sqltools","sqltools-driver"],"license":"MIT","category":"databases-storage","readme_excerpt":"VS Code SQLTools for DuckDB Query and explore DuckDB databases in VSCode. Latest DuckDB Support: v1.3.2 A VSCode extension that extends SQLTools, with a driver for DuckDB. This driver is maintained by Evidence: Publish BI reports with just SQL and Markdown. Install Install from the VSCode Marketplace. Features - Latest DuckDB support (currently 1.3.2) - Connect to a local, in-memory or MotherDuck (via service token) DuckDB instance - Run queries against a DuckDB instance - Explore DB tables and columns in the sidebar - View table results by selecting them in the sidebar - Autocomplete for common keywords (e.g. SELECT, FROM, WHERE) and table names - Read/Write connections Connect Local and In-Memory DBs Run Query Explore DB Autocomplete Read/Write Connections DuckDB has two access modes: 1. Read/Write: One process can both read and write to the database. 2. Read Only: Multiple processes can read from the database, but no processes can write. If you open another connection to a database that is already open in read/write mode, you may get an error. Close the read/write connection to resolve this. More Info Not Supported - Loading extensions not included in the default Node.js installation DuckDB Extensions Supported For clarity, the following DuckDB extensions are supported Extension Supported ------------------ ----------- arrow autocomplete fts httpfs icu 1 inet jemalloc json 1 motherduck 1 parquet 1 postgres scanner spatial sqlite scanner tpcds tpch MotherDuck To use MotherD","default_branch":null,"files":null,"tree":[],"storefront":"/r/evidence-dev","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/evidence-dev/sqltools-duckdb-driver/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}