Supported engines

PostgreSQL

Native driver

Full PostgreSQL support with connection pooling, metadata introspection, and intelligent autocomplete across all your schemas.

  • [+]Connection pooling for reuse and concurrency
  • [+]Automatic metadata crawling across databases, schemas, and tables
  • [+]Foreign-key aware JOIN suggestions
  • [+]Query cancellation for long-running queries

MySQL

Native driver

MySQL connector with proper identifier quoting, dedicated metadata extraction, and full autocomplete support.

  • [+]Native async connectivity
  • [+]Backtick identifier quoting in generated SQL
  • [+]Schema, table, and column metadata extraction
  • [+]Same IDE experience across all engines

Snowflake

REST API

Comprehensive Snowflake connector with support for all three authentication methods and efficient large result set handling.

  • [+]Three auth methods: User/Password, Key-Pair, and SSO browser
  • [+]Session token caching with automatic refresh
  • [+]Automatic role, warehouse, database, and schema selection
  • [+]Efficient handling of large partitioned result sets

DuckDB

Embedded

Built-in DuckDB for local analytics — no external server required. Query local files and in-memory databases directly.

  • [+]Bundled — no separate install required
  • [+]Local file and in-memory analytics
  • [+]Same IDE experience across all engines
Snowflake large result sets

Large Snowflake result sets

When Snowflake returns large result sets, the API splits rows across multiple partition URLs instead of returning them inline. DataBook Studio handles this transparently — downloading, decompressing, and assembling the complete result set for you with no manual intervention.

01

Transparent Downloads

Partition chunks are downloaded and assembled automatically — you see the complete result set as if it were a single response.

02

Automatic Decompression

Compressed payloads are decompressed transparently so you always get clean, readable data.

03

Concurrent Fetching

Multiple chunks download in parallel for fast results, with early termination when row limits are reached.

04

Proper Value Handling

Snowflake-specific value formats are unwrapped to raw values during row mapping for clean display.