---
title: "Reference"
slug: "dev-database-reference"
updated: 2026-11-05T22:32:55Z
published: 2026-11-05T22:32:55Z
canonical: "docs.vastdata.com/dev-database-reference"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vastdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Reference

Exact facts to look up while you work. Start with the Cheat sheet for the common SDK calls and the Python SDK reference for every signature; Limits, Data types, Pushdowns and Version compatibility answer specific questions, and the SQL reference covers the VAST Query Engine.

- **[Python SDK reference](/develop/docs/dev-database-reference-sdk)**: API reference for vastdb 2.1.0: sessions, transactions, schemas, tables, select, insert, imports, partitions, projections, configuration and exceptions.
- **[Data types](/develop/docs/dev-database-reference-data-types)**: Supported column types named in Arrow, Trino, Spark and the Python SDK, with precision caveats, vectors and types the SDK can't use.
- **[Pushdowns](/develop/docs/dev-database-reference-pushdowns)**: Which operations and predicates VAST DataBase evaluates on its CNodes next to the data, and how the SDK and Trino use them.
- **[Limits](/develop/docs/dev-database-reference-limits)**: Size and count limits for tables, what can't be changed later, which table structures combine, and partition transforms.
- **[Version compatibility](/develop/docs/dev-database-reference-versions)**: Which vastdb SDK works with your cluster, which SDK features need a newer cluster, and which Trino, Spark and ADBC versions fit.
- **[Cheat sheet](/develop/docs/dev-database-reference-cheat-sheet)**: One page of the Python SDK calls you'll use most, filters that push down, main limits, permissions and where to look next.
- **[Automation tools](/develop/docs/dev-database-reference-automation-tools)**: Compare the VMS REST API, vastpy, Terraform provider and admin MCP server: coverage per service, authentication, API versions and limits.
- **[SQL reference](/develop/docs/dev-database-reference-sql)**: The SQL the VAST Query Engine accepts in VAST Cluster 5.5, one page per statement. Start with Overview for how statements reach the engine, then SELECT; check What the VAST Query Engine doesn't support before you write joins or GROUP BY.