# Managed DuckDB for lakehouse analytics

> Run managed DuckDB SQL on open lakehouse storage with fast analytics, federated catalogs, predictable compute, and agent access.

Managed DuckDB



DuckDB SQL on managed compute, open Parquet storage, federated catalogs, and MCP access for teams and agents.

[Start for free](/sign-up) [Read the docs](/docs/lakehouse/compute/workers.md)

Core architecture

## DuckDB execution, without DuckDB ops

Workers run DuckDB SQL, cache hot data, connect external sources, and return results over SQL clients, APIs, and MCP. Storage stays in object storage. Compute scales independently.

![DuckDB execution, without DuckDB ops](/assets/illus/product/duckdb-compute-storage.png)

![Managed Workers](/assets/illus/product/icons/auto-scaling-compute.png)

##### Managed Workers

Run DuckDB SQL on Altertable-managed compute without operating infrastructure yourself.

![DuckDB SQL](/assets/illus/product/icons/warehouse-level-performance.png)

##### DuckDB SQL

Standard DuckDB syntax and types across managed and external catalogs.

![Parquet storage](/assets/illus/product/icons/open-standards.png)

##### Parquet storage

Managed catalogs stored as Parquet in object storage.

![Federated SQL](/assets/illus/product/icons/product-analytics.png)

##### Federated SQL

Join lakehouse tables with Postgres, warehouses, bucket tables, and Iceberg.

![Hot-data caching](/assets/illus/product/icons/multi-tier-caching.png)

##### Hot-data caching

Local caching on Workers for faster repeat queries.

![MCP for agents](/assets/illus/product/icons/mcp-tool-adapter.png)

##### MCP for agents

OAuth-scoped agent access. No shared database credentials.

Production runtime

## One runtime for teams and agents

Local DuckDB does not cover shared access, durable storage, federation, or governance. Altertable adds the operational layer so DuckDB-style SQL can run in production.

![One runtime for teams and agents](/assets/illus/product/humans_agents_data.png)

![Shared lakehouse catalogs](/assets/illus/product/icons/query-local-storage.png)

##### Shared lakehouse catalogs

Managed catalogs backed by buckets and Parquet files.

![APIs and SQL clients](/assets/illus/product/icons/mcp-integration.png)

##### APIs and SQL clients

HTTP API, Arrow Flight SQL, and Postgres-compatible clients.

![BI and dbt](/assets/illus/product/icons/analytics-dashboard.png)

##### BI and dbt

Connect existing BI and transformation tools to the same runtime.

![Self-hosted Workers](/assets/illus/product/icons/auto-scaling-compute.png)

##### Self-hosted Workers

Run compute next to your buckets when locality or egress matters.

## What you get

DuckDB speed with the ops layer production teams need.

![Shared SQL environment](/assets/illus/product/built_for_devs.png)

#### Shared SQL environment

One shared runtime instead of laptop-local .duckdb files.

![Less warehouse gravity](/assets/illus/product/low_latency_cost_efficiency.png)

#### Less warehouse gravity

Run lakehouse workloads without routing every use case through a central warehouse.

![Open Parquet storage](/assets/illus/product/ecosystem_ready.png)

#### Open Parquet storage

Data stays in portable object-storage formats, not a proprietary layer.

![Agent-ready access](/assets/illus/product/agents_surface_anomalies.png)

#### Agent-ready access

Agents query live data through MCP, not copied credentials.

## Frequently asked questions

### Is Altertable hosted DuckDB?

Altertable runs DuckDB SQL, but adds managed catalogs, object storage, federation, APIs, caching, and MCP access.

### Can I query existing DuckDB files?

Yes. A `.duckdb` file in a connected bucket can be exposed as a read-only external catalog. Use Altertable catalogs when you want Altertable to own writes and retention.

### Where does compute run?

On Altertable-managed Workers, or on self-hosted Workers you deploy in your own environment.

### Does it replace my warehouse?

Yes. Altertable can be your primary analytical runtime for interactive SQL, Parquet storage, dashboards, and agent access. External catalogs let you query existing sources during migration or alongside the lakehouse.

## Explore the rest of the platform

More workloads on the same engine, governance, and pricing.

[![Cousteau](/assets/illus/product/explore-cousteau.png)](/product/cousteau.md)

#### [Cousteau](/product/cousteau.md)

[Investigate product changes across events, logs, customer data, and code. Cousteau brings back what changed, why, and who is affected.](/product/cousteau.md)

[![Self-serve BI](/assets/illus/product/explore-self-serve-bi.png)](/product/self-serve-bi.md)

#### [Self-serve BI](/product/self-serve-bi.md)

[Give every team live dashboards, shared metrics, and agent-assisted exploration on the same governed data foundation.](/product/self-serve-bi.md)

## Run DuckDB SQL on a managed lakehouse

DuckDB workers on open formats, federated SQL across your existing systems,\
and an MCP server for agents — at flat monthly pricing.

[Start 14-day free trial](/sign-up)

[Web version](https://altertable.ai/solutions/managed-duckdb)
