Is this skill compatible with Python or Clojure?

The skill provides standardized SQL interfaces and implementation patterns for Python (SQLAlchemy/DuckDB), Clojure (duckdb.core), and Ruby.

How does the skill handle data consistency?

It uses the 'Same data → Same structure' principle (SPI guarantee) and provides PRAGMA commands to freeze tables, ensuring identical query results for reproducible execution.

Can I export temporal data to other formats?

Yes, the skill includes patterns for exporting versioned data and audit logs to CSV, JSON, and Parquet formats for external analysis.

What is time-travel querying in this skill?

Time-travel querying allows you to execute SQL statements against the database as it existed at a specific past transaction ID or timestamp, enabling historical data recovery and analysis.

DuckDB Temporal Versioning

Name: DuckDB Temporal Versioning
Author: plurigrid

byplurigrid

•

数据库管理

Enables time-travel SQL queries and deterministic interaction history using embedded DuckDB databases.

The DuckDB Temporal Versioning skill provides advanced data management capabilities for Claude, allowing it to implement and query databases with built-in history tracking. By leveraging temporal semantics, developers can query data as it existed at any transaction point, track event causality via vector clocks, and maintain immutable audit logs. This is ideal for scenarios requiring high reproducibility, detailed auditing, or complex historical analysis without the need for a standalone database server.

主要功能

012 GitHub stars

02Deterministic execution via frozen database snapshots

03Multi-layered query strategies for history, world, and unified views

04Automated immutable audit logging using 3-trigger patterns

05Time-travel queries using VERSION AT SYSTEM_TIME syntax

06Causality tracking with integrated vector clock schemas

使用场景

01Analyzing historical user interactions and system state evolution

02Implementing comprehensive audit trails for regulatory compliance

03Building reproducible data pipelines for machine learning and testing

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add plurigrid/asi duckdb-temporal-versioning

For use in Claude.ai and ChatGPT

Download Skill