DuckDB SQL Query Tool and SQL Editor Features
RazorSQL includes support for the DuckDB database. RazorSQL allows users to browse DuckDB tables, columns, and views. It has an SQL editor that gives users the ability to write SQL queries against the DuckDB database. It includes an import tool for importing data into DuckDB and an export tool for exporting data in various formats from DuckDB. For information on getting connected to Duck from RazorSQL, see the following page: Getting Connected to DuckDB
|
Browse DuckDB tables, views, and columns. Expand tables to see column lists.
Describe DuckDB tables to see table structures.
|
|
The SQL editor allows users to write and execute queries against DuckDB tables and views.
The SQL editor includes features such as auto column and table lookup, synax highlighting,
many coding features such as key ahead, code snippets, macros, and more. It supports
over 20 different programming languages including SQL, HTML, XML, Java, PHP, and many more.
|
|
Import data into DuckDB tables from delimited files, spreadsheets, fixed width files,
or SQL scripts.
|
|
Export DuckDB data in various formats such as delimited files, Excel spreadsheets, text,
HTML, XML, and SQL insert statements.
|
|
Build select, insert, delete, and update SQL queries. |