Exploring DuckDB information schema, metadata functions, pg_catalog views and more in VSCode IDE SQLTools Connections Explorer

[RandomFractals]

This is a new feature recently added to our DuckDB Pro Tools private beta release, in addition to display of DuckDB instance databases, schemas, indexes, sequences, extensions, functions, types, configuration settings, and reserved keywords. See our FAQ about DuckDB SQL vs Pro Tools at: https://github.com/RandomFractals/duckdb-sql-tools/discussions

New DuckDB Objects Tree View

PG Catalog

DuckDB provides many standard PostgreSQL pg_catalog functions and views for compatibility with PostgreSQL database and SQL syntax. You can explore those internal DuckDB views and function signatures via pg_catalag schema in the DuckDB Objects tree view.

DuckDB Objects and Views

DuckDB Pro Tools v1.1.0 and higher DB Objects tree view also shows the full list of DuckDB indexes, sequences, information_schema and other custom duckdb metadata functions and internal views.

DuckDB Views

Indexes

Sequences

Extensions

Functions

DuckDB Types

DuckDB SQL Keywords

Configuration Settings

New DuckDB configuration settings display with setting type icons and current values in the DuckDB Objects tree view item description.

Table and View Columns

DuckDB configuration settings, database schema types, table and view columns now show basic data type icons for strings, numeric, date and timestamp columns and setting types.

Additionally, DuckDB Pro Tools v1.1.0 and higher display primary columns in tables, and not null column value constraints.