skills.rest
fatcrapinmybutt
fatcrapinmybuttCOMMUNITY
Explore all skills by this author →
GitHub

SINGULARITY-data-dominion

Coordinate SQL workflows, DuckDB analytics, LanceDB vectors, and cross-database federation across SQLite, DuckDB, and Polars.

Updated Aug 27, 2026
Search Tags:#database#rag#sqlite#duckdb#polars#data-engineering#vector-search
One-click install
npx skills add https://github.com/fatcrapinmybutt/cortex-osint --skill singularity-data-dominion
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: SINGULARITY-data-dominion
Source: https://github.com/fatcrapinmybutt/cortex-osint/tree/main/.agents/skills/SINGULARITY-data-dominion
Command: npx skills add https://github.com/fatcrapinmybutt/cortex-osint --skill singularity-data-dominion

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides end-to-end data engineering and database mastery for LitigationOS, enabling efficient SQL optimization, vector-based retrieval, and scalable cross-database workflows across SQLite, DuckDB, LanceDB, and Polars.

Core Features & Use Cases

  • Layered database mastery: SQL tuning, FTS5 efficiency, vector embeddings, and RAG pipelines for large litigation datasets.
  • Cross-database federation and analytics: seamless querying across SQLite, DuckDB, LanceDB, and Polars to accelerate investigations.
  • Real-world use: streamline e-discovery, evidence indexing, and rapid analytical dashboards for complex cases.

Quick Start

Load your data and run the recommended pipeline to initialize analytics and vector search.

Frequently Asked Questions about SINGULARITY-data-dominion

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

FAQPage Schema
How do I set up a RAG pipeline with SQLite and DuckDB for large document datasets?▼

Set up a RAG pipeline with SQLite and DuckDB by attaching cross-database federation, configuring FTS5 search, and building vector embeddings in LanceDB for rapid evidence retrieval.

What's the best way to query across SQLite, DuckDB, and Polars in a single workflow?▼

Query across SQLite, DuckDB, and Polars using cross-database attachment and federation to enable seamless schema introspection and unified analytics without manual data migration.

How does vector indexing in LanceDB work with DuckDB analytics?▼

Vector indexing in LanceDB works with DuckDB analytics by separating vector retrieval from columnar processing, enabling RAG pipelines to query embeddings and structured data concurrently.

Can I optimize SQLite PRAGMA settings for large-scale e-discovery workflows?▼

Optimize SQLite PRAGMA settings for e-discovery by applying batch operations and robust error handling to tune performance during large-scale evidence indexing and FTS5 search.

Does cross-database federation across SQLite and DuckDB support schema introspection?▼

Cross-database federation across SQLite and DuckDB supports schema introspection, allowing robust error handling and dynamic querying across attached databases during litigation analytics.

Why does my FTS5 search return errors during batch operations in SQLite?▼

FTS5 search returns errors during SQLite batch operations when schema introspection fails or PRAGMA tuning is misconfigured, requiring robust error handling to resolve attachment conflicts.

Related Skills

Explore More Data & Analytics Skills→
nettenette
41

nette-database

Map database tables to typed Row entities in Nette Database with Explorer.

Official
Advanced
legoutlegout
3

duckdb

Execute SQL analytical queries on local files and DataFrames.

Community
Intermediate
ahostbrahostbr

ls-conversation-lookup

Locate Claude Code conversation JSONL artifacts by ID prefix or ranked search.

Community
Advanced
yale-som-hpcyale-som-hpc
5

working-with-large-data

Process terabyte-scale datasets out-of-core with Parquet, DuckDB, Polars, and Arrow.

Official
Advanced