Downloads 258this week

GitHub stars 9

Extension repository on GitHub

Extension descriptor (YAML)

Read Microsoft PST files with rich schemas for common MAPI types (emails, contacts, appointments, tasks)

Installing and Loading

INSTALL pst FROM community;
LOAD pst;

Example

-- Count all messages across PST files (supports globs)
D SELECT count(*) FROM read_pst_messages('enron/*.pst');
┌────────────────┐
│  count_star()  │
│     int64      │
├────────────────┤
│    1227193     │
└────────────────┘

-- Query contacts (supports remote URIs)
D SELECT given_name, surname FROM read_pst_contacts('https://example.com/outlook.pst');
┌────────────┬─────────┐
│ given_name │ surname │
│  varchar   │ varchar │
├────────────┼─────────┤
│ John       │ Doe     │
│ Jane       │ Smith   │
└────────────┴─────────┘

-- Read messages with limit (applied during planning for large files)
D SELECT subject, sender_email_address, message_delivery_time
  FROM read_pst_messages('*.pst', read_limit=100);

About pst

A DuckDB extension for reading Microsoft PST files with rich schemas for common MAPI types. Built on Microsoft's official PST SDK. Query emails, contacts, appointments, and more. Use it to analyze PST data in-place (locally or on object storage), import to DuckDB tables, or export to Parquet.

Table Functions

Performance Features

• Query pushdown: projection and statistics pushdown
• Concurrent planning: parallel partition planning for directories with many PST files
• Late materialization: filter on virtual columns before expanding full projections

Parameters

For full schema documentation and usage examples, see the GitHub repository.

Added Functions