> This page is for Developer Documentation.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.benchling.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.benchling.com/_mcp/server.

# Warehouse and Data

The Benchling Warehouse is a read-only SQL database that mirrors your tenant's data. Use it
when you are more comfortable in SQL than in the REST API, when you need large amounts of
data at once, or when you are connecting a third-party analytics or visualization tool.

The Warehouse uses its own credentials, separate from the API authentication methods
described in [Authentication](/docs/authentication). Data syncs on a delay, so if you need
values guaranteed current, read them through the [REST API](/docs/rest-api-reference)
instead.

## Getting Started

[Getting Started with the Warehouse](/docs/getting-started) covers requesting access,
connecting, and running your first query.

## Querying the Warehouse

* [Warehouse Tables](/docs/warehouse-tables) explains how the schema is laid out and the
  joins you will reach for most.
* [Multi-Tables](/docs/multi-tables) covers the `$raw` tables and the per-schema tables
  built on top of them.
* [Custom Warehouse Views](/docs/custom-warehouse-views) walks through defining your own
  views from the Insights SQL editor.
* [SQL Queries Hints (Advanced)](/docs/sql-queries-hints) collects performance notes for
  large queries.

## Table Reference

A per-domain reference for the tables the Warehouse exposes.

[Users, Teams and Projects](/docs/wh-users-teams-projects) ·
[Registry](/docs/wh-registry) · [Molecular Biology](/docs/wh-mol-bio) ·
[Results and Runs](/docs/wh-results-runs) · [Notebook](/docs/wh-notebook) ·
[Notebook Entry Tables](/docs/wh-notebook-entries) ·
[Notebook Review Tables](/docs/wh-notebook-review-tables) ·
[Notebook Worksheet Tables](/docs/wh-notebook-worksheet-tables) ·
[Inventory](/docs/wh-inventory) · [Requests](/docs/wh-requests) ·
[\[Beta\] Biologics](/docs/biologics) ·
[\[Beta\] Procedures](/docs/wh-procedures) · [Workflows](/docs/wh-workflows) ·
[Legacy Workflows](/docs/wh-legacy-workflows) · [Mixtures and Batches](/docs/wh-mixtures) ·
[Studies](/docs/wh-studies) · [Deprecated Tables](/docs/wh-deprecated)

## Moving data in and out

For loading data into Benchling or exporting it through the API rather than the Warehouse,
see [Importing Data with the Bulk Import API](/docs/bulk-import) and
[Exporting Data with the Bulk Export API](/docs/bulk-export). The
[Data Lake Integration](/docs/data-lake-integration) accelerator covers the export,
change-monitoring, and insert components of a data lake pipeline.