DOCS
← Back to Glossary
extension
An extension in DuckDB is a modular component that adds functionality to the core database system.
An extension in DuckDB is a modular component that adds functionality to the core database system. These extensions allow users to incorporate additional features, data types, or integrations without modifying the main codebase. DuckDB's extension system enables users to load specialized capabilities on-demand, such as support for geospatial data, full-text search, or connectivity to external data sources. Extensions can be installed and loaded using SQL commands, making it easy for data analysts and engineers to enhance their DuckDB environment as needed. For example, to install and load the JSON extension, you would use:
Copy code
INSTALL json; LOAD json;
Related terms
MotherDuck extension →
The MotherDuck extension is a component of DuckDB that enables seamless integration with the MotherDuck cloud service.
httpfs extension →The httpfs extension is DuckDB's built-in module for reading and writing files directly over HTTP(S) and from S3-compatible object storage, Azure, and Google Cloud Storage, without downloading them first.
DuckDB →DuckDB is an embeddable SQL database management system designed for analytical workloads.
SQL →SQL (Structured Query Language) is the standard language for working with relational databases.
Postgres →PostgreSQL, often referred to as Postgres, is a powerful open-source relational database management system.
dot-commands-duckdb →This guide dives into the realm of dot commands, which are special commands that enhance the functionality of the DuckDB CLI, making it even more versatile…
