Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.tablepro.app/llms.txt

Use this file to discover all available pages before exploring further.

​
DuckDB

DuckDB is an embedded analytical database, optimized for OLAP workloads. TablePro supports connecting to DuckDB database files for browsing tables, running queries, and managing schemas. The DuckDB driver plugin (1.0.19) bundles DuckDB 1.5.2, with DuckLake 1.0 support.

​
Connecting to a DuckDB database

1

Create a new connection

Open TablePro and click New Connection or press ⌘N.
2

Select DuckDB

Choose DuckDB from the database type list.
3

Choose your database file

Click Browse to select an existing .duckdb file, or enter the path to create a new database.
4

Connect

Click Connect to open the database.

​
Connection URL

duckdb:///path/to/database.duckdb
See Connection URL Reference for all parameters.

​
Opening DuckDB files from Finder

Double-click any .duckdb file in Finder to open it directly in TablePro.

​
Querying files directly

DuckDB can query CSV, Parquet, and JSON files directly with SQL: 
-- Query a CSV file
SELECT * FROM 'data.csv';

-- Query a Parquet file
SELECT * FROM read_parquet('analytics.parquet');

-- Query a JSON file
SELECT * FROM read_json('config.json');

​
Schema support

DuckDB supports multiple schemas within a single database. The default schema is main. Use the schema switcher in the toolbar to navigate between schemas. 
-- Create a new schema
CREATE SCHEMA analytics;

-- Create a table in a specific schema
CREATE TABLE analytics.events (
    id INTEGER PRIMARY KEY,
    event_name VARCHAR,
    created_at TIMESTAMP
);

​
DuckDB extensions

DuckDB has a rich extension ecosystem. Install and load extensions using SQL: 
-- Install an extension
INSTALL httpfs;

-- Load an extension
LOAD httpfs;

-- Query remote Parquet files
SELECT * FROM read_parquet('https://example.com/data.parquet');

​
Data types

DuckDB supports a wide range of data types:
CategoryTypes
NumericINTEGER, BIGINT, HUGEINT, DOUBLE, FLOAT, DECIMAL
StringVARCHAR, TEXT, CHAR
Date/TimeDATE, TIME, TIMESTAMP, INTERVAL
ComplexLIST, MAP, STRUCT, UNION, ENUM
OtherBOOLEAN, BLOB, UUID, JSON, BIT

​
Limitations

DuckDB is embedded (no network access) and allows only one writer at a time.