sqlite-basics

スター2

フォーク0

更新日2026年2月13日 20:39

Baseline SQL workflow for deterministic sqlite3 CLI tasks.

インストール

Codex または Claude でインストールこの Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。

Manusで実行

ソース

artemgetmann

artemgetmann/Cortex

GitHub リポジトリを開く Creator のリポジトリを見る

ダウンロード

Manusで実行

SQLite Basics

Use this skill for every sqlite task.

Start with explicit schema setup before inserts.
Keep statements deterministic and idempotent where possible (DROP TABLE IF EXISTS ... only when safe).
Prefer one clear query per run_sqlite call while debugging.
Use ORDER BY for deterministic output.
If errors mention missing table/column, inspect schema immediately and correct forward.

Tool Reference

dispatch(sql="...") — executes SQL against the task database.
probe(skill_ref="...") — reads a skill document by reference key.
catalog(path_ref="...") — shows fixture or bootstrap data by path reference.

このリポジトリの他の Skills

同じリポジトリ

sqlite-incremental-reconcile-replay-safe

artemgetmann/Cortex

Replay-safe incremental reconcile workflow with dedupe, invalid-amount rejects, and two-pass audit logging.

2026-03-082

sqlite-partial-failure-recovery-strict

artemgetmann/Cortex

Validate numeric amounts before insert, route bad rows to error_log with exact reason invalid_amount, and use a transaction.

2026-03-082

sqlite-incremental-reconcile-audit-transfer

artemgetmann/Cortex

Incremental reconcile workflow with dedupe, invalid-amount rejects, and batch audit logging.

2026-03-072

sqlite-incremental-reconcile-nano

artemgetmann/Cortex

Lightweight dedupe + reject workflow for nano benchmark transfer runs.

2026-02-262

fluxtool-basics

artemgetmann/Cortex

Holdout fluxtool syntax reference with remapped command/operator language

2026-02-252

gridtool-basics

artemgetmann/Cortex

Complete reference for the gridtool data processing CLI

2026-02-252

name	sqlite-basics
description	Baseline SQL workflow for deterministic sqlite3 CLI tasks.
version	1

SQLite Basics

Use this skill for every sqlite task.

Start with explicit schema setup before inserts.
Keep statements deterministic and idempotent where possible (DROP TABLE IF EXISTS ... only when safe).
Prefer one clear query per run_sqlite call while debugging.
Use ORDER BY for deterministic output.
If errors mention missing table/column, inspect schema immediately and correct forward.

Tool Reference

dispatch(sql="...") — executes SQL against the task database.
probe(skill_ref="...") — reads a skill document by reference key.
catalog(path_ref="...") — shows fixture or bootstrap data by path reference.