DuckDB provides a number of functions and PRAGMA options to retrieve information on the running DuckDB instance and its environment.

Version

The version() function returns the version number of DuckDB.

SELECT version() AS version; 

Using a PRAGMA:

PRAGMA version; 

Platform

The platform information consists of the operating system, system architecture, and, optionally, the compiler. The platform is used when installing extensions. To retrieve the platform, use the following PRAGMA:

PRAGMA platform; 

On macOS, running on Apple Silicon architecture, the result is:

On Windows, running on an AMD64 architecture, the platform is windows_amd64. On CentOS 7, running on the AMD64 architecture, the platform is linux_amd64_gcc4. On Ubuntu 22.04, running on the ARM64 architecture, the platform is linux_arm64.

Extensions

To get a list of DuckDB extension and their status (e.g., loaded, installed), use the duckdb_extensions() function:

SELECT * FROM duckdb_extensions(); 

Meta Table Functions

DuckDB has the following built-in table functions to obtain metadata about available catalog objects:

• duckdb_columns(): columns
• duckdb_constraints(): constraints
• duckdb_databases(): lists the databases that are accessible from within the current DuckDB process
• duckdb_dependencies(): dependencies between objects
• duckdb_extensions(): extensions
• duckdb_functions(): functions
• duckdb_indexes(): secondary indexes
• duckdb_keywords(): DuckDB's keywords and reserved words
• duckdb_optimizers(): the available optimization rules in the DuckDB instance
• duckdb_schemas(): schemas
• duckdb_sequences(): sequences
• duckdb_settings(): settings
• duckdb_tables(): base tables
• duckdb_temporary_files(): the temporary files DuckDB has written to disk, to offload data from memory
• duckdb_types(): data types
• duckdb_views(): views