skills.rest
plurigrid
plurigridOFFICIAL
Explore all skills by this author →
Website𝕏@plurigridGitHub

duckdb-timetravel

Generate DuckDB schemas from ACSet definitions and query historical versions.

60|13|Updated Dec 22, 2025
Search Tags:#versioning#schema#duckdb#temporal#ACSet#time-travel
One-click install
npx skills add https://github.com/plurigrid/asi --skill duckdb-timetravel
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: duckdb-timetravel
Source: https://github.com/plurigrid/asi/tree/main/skills/duckdb-timetravel
Command: npx skills add https://github.com/plurigrid/asi --skill duckdb-timetravel

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Enables temporal versioning for interaction data and integrates with ACSet definitions to generate DuckDB schema for time-travel queries.

Core Features & Use Cases

  • Temporal queries: query historical states with versioning.
  • Version management: checkpoint, list, and restore versions.
  • ACSet-to-DuckDB schema: generate schema templates from ACSet definitions.

Quick Start

Create a version checkpoint, then query or restore to a previous state.

Frequently Asked Questions about duckdb-timetravel

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query historical states in DuckDB with temporal versioning?▼

Temporal versioning in DuckDB enables querying historical snapshots of interaction data. Create version checkpoints, then use time-travel SQL syntax to restore or analyze data at specific points in time without maintaining separate copies.

Can I generate DuckDB schema automatically from ACSet definitions?▼

Yes. The ACSsetSchemaGenerator component generates DuckDB schema templates directly from ACSet definitions, eliminating manual schema design and ensuring consistency across GF(3)-constrained datasets.

What's the best way to manage multiple versions of interaction data?▼

Use the VersionManager API to checkpoint, list, and restore versions of interaction data. This approach supports diffing between versions and automated validation, replacing manual version tracking with structured version management.

Does DuckDB support time-travel queries for analytics workflows?▼

DuckDB supports time-travel queries through temporal versioning syntax. This Skill implements the infrastructure to enable historical querying, version snapshots, and schema validation across temporal datasets.

What are the limitations when using ACSet schemas with temporal versioning?▼

ACSet schemas operate within GF(3) constraints, restricting the logical structure of datasets. Temporal versioning applies uniformly across all versions, so schema changes between checkpoints require explicit migration or version isolation strategies.

Related Skills

Explore More Data & Analytics Skills→
zocomputerzocomputer
45

zo-dataset-creator

Create and validate Zo Datasets with schema generation from DuckDB.

Official
Intermediate
nexscope-ainexscope-ai
38

ecommerce.ozon-product-trend

Retrieve daily Ozon SKU performance data including sales, price, and stock.

Official
Intermediate
LeoyishouLeoyishou
27

lake

Query Parquet/CSV data with a DuckDB-backed lakehouse engine.

Community
Advanced
emilneuraz-aiemilneuraz-ai

projection-patterns

Build projections and read models from event streams for CQRS queries.

Community
Advanced