> ## Documentation Index > Fetch the complete documentation index at: https://planetscale.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # Extensions: pg_duckdb > pg_duckdb is a Postgres extension that embeds DuckDB, a high-performance analytical database, directly into Postgres. export const PlatformAvailability = ({current, vitess, postgres}) => { const docsHref = path => { if (!path) return path; const normalized = path.startsWith('/') ? path : `/${path}`; return normalized; }; const labels = { vitess: 'Vitess', postgres: 'Postgres' }; if (current === 'both') { return

Vitess and Postgres

; } const hasVitess = current === 'vitess' || Boolean(vitess); const hasPostgres = current === 'postgres' || Boolean(postgres); const only = !(hasVitess && hasPostgres); const engines = []; if (current === 'vitess' || current === 'postgres') engines.push(current); if (hasVitess && current !== 'vitess') engines.push('vitess'); if (hasPostgres && current !== 'postgres') engines.push('postgres'); return

{engines.map(engine => { const isCurrent = current === engine; const href = docsHref(engine === 'vitess' ? vitess : postgres); const label = only ? `${labels[engine]} only` : labels[engine]; const state = isCurrent || !href ? 'current' : 'link'; if (isCurrent || !href) { return {label} ; } return {label} ; })}

; }; We don't recommend running `pg_duckdb` directly on your PlanetScale Postgres database as it can consume significant resources during analytical queries. If you want to use DuckDB for analytics, we recommend using [MotherDuck](https://motherduck.com/) to host your analytical workloads separately. ## Dashboard Configuration This extension requires activation via the PlanetScale dashboard before it can be used. It must be enabled through shared libraries and requires a database restart. To enable pg\_duckdb: From the PlanetScale organization dashboard, select the desired database Navigate to the **Clusters** page from the menu on the left Choose the branch whose extensions you'd like to configure in the "**Branch**" dropdown Select the **Extensions** tab Enable `pg_duckdb` and configure its parameters Click **Queue extension changes** to apply the configuration Once you're ready to apply the changes, click "**Apply changes**" ## Parameters ### duckdb.postgres\_role * **Type**: String * **Default**: `pscale_superuser` * **Description**: Specifies the Postgres role that is allowed to use DuckDB execution and manage secrets. ### duckdb.memory\_limit * **Type**: Integer * **Default**: 0 * **Description**: Maximum memory DuckDB can use per connection in megabytes. Setting to 0 activates DuckDB's default (80% of available RAM). ## Usage After enabling the extension through the dashboard, you can install it in your database: ```sql theme={null} CREATE EXTENSION IF NOT EXISTS pg_duckdb; ``` Once installed, you can use DuckDB's analytical capabilities directly from PostgreSQL. For example: ```sql theme={null} -- Query PostgreSQL tables using DuckDB's analytical engine SELECT * FROM duckdb.read_parquet('s3://bucket/data.parquet'); ``` ## External Documentation For more detailed information about `pg_duckdb` usage and functionality, see the [official `pg_duckdb` documentation](https://github.com/duckdb/pg_duckdb).