Research Overview Tracks Agenda

SkeinQL Research Extensions (Experimental)ΒΆ

Last updated: 2026-05-14

This document lists experimental SkeinQL method families that support the 20-proposal research agenda.

Principles: - These methods are not required for MySQL compatibility. - They should be implemented behind feature flags and exposed only when enabled. - For each family, the canonical research description is in docs/research_agenda/. - Use docs/SKEINQL.md for method payload examples and docs/API_REFERENCE.md for the v0.3.18 runtime method map exposed through system.capabilities.

1. dp.* β€” Differential privacyΒΆ

Related: R04

  • dp.aggregate β€” COUNT/SUM/AVG aggregates with explicit DP parameters, bounded sensitivities, and privacy_etag validators
  • dp.evaluate β€” seeded accuracy-vs-epsilon and overhead-vs-exact report for bounded DP aggregate plans
  • dp.budget.get / dp.budget.set β€” persisted per-principal budget tracking and policies
  • dp.audit.log β€” persisted budget consumption events

2. oblivious.* β€” Oblivious execution policiesΒΆ

Related: R05

  • oblivious.policy.get / oblivious.policy.set
  • oblivious.explain β€” show which operators will be padded/shuffled
  • oblivious.evaluate β€” deterministic trace-based leakage and overhead report for the active table policy

3. forensic.* β€” Forensic WAL queries with proofsΒΆ

Related: R06

  • forensic.query β€” run table/op/id-bounded forensic queries with the SkeinForensic JSON filter grammar and return boundary, checkpoint-anchor, Merkle-root, inclusion-proof, and index-summary metadata
  • forensic.verify β€” verify contiguous returned record slices against a supplied start hash
  • forensic.export β€” export skein.forensic.bundle.v1 report bundles with the query manifest, records, proof, and verification summary

4. merge.* β€” Optimistic writes with merge semanticsΒΆ

Related: R07

  • merge.register β€” register a per-table merge policy with built-in or values-only Wasm functions
  • merge.apply β€” apply a policy to an incoming row with ETag/min-causality conflict hooks
  • merge.simulate β€” test current+incoming row merges without committing
  • merge.evaluate β€” report conflict rate, resolution success, and merge timing for example workloads
  • merge.wasm.register / merge.wasm.list / merge.wasm.drop β€” manage values-only Wasm merge modules

5. view.* β€” Materialized views + incremental maintenanceΒΆ

Related: R08

  • view.create / view.drop
  • view.refresh β€” incremental, full, or auto refresh for restricted single-table views (including grouped views)
  • view.evaluate β€” read-only incremental-vs-full correctness oracle and timing report
  • view.status β€” lag/last refresh
  • view.explain_deps β€” dependency graph edges

6. transport.* β€” Protocol negotiation hintsΒΆ

Related: R09

  • transport.capabilities β€” advertise supported transports (HTTP/1.1, HTTP/2, QUIC); the QUIC runtime has framing, prepared-query, 0-RTT write rejection, rebind coverage, and the companion skeindb transport-bench CLI for comparative p99 checks against HTTP/2 and MySQL/TCP

Related: R10

  • vector.insert β€” store embedding values (ValueKind::Embedding)
  • vector.search β€” ANN query (HNSW when available, with LSH bucket filtering as the prototype fallback) with cache validators, table-version dependency metadata, V2 causality tokens, and source-change invalidation
  • vector.benchmark β€” exact brute-force vs indexed top-k recall and latency report for embedding columns
  • vector.index.status β€” index health and coverage

See Vector RAG retrieval for a credential-free sample application that uses vector.insert and vector.search to assemble grounded context.

8. ai.* β€” AI-assisted query workflowsΒΆ

Related: R11, R12

  • ai.autoparam.classify β€” classify literals (semantic-constant vs parameterizable)
  • ai.autoparam.analyze β€” extract literals from SQL and classify them
  • ai.nl.translate β€” prompt packaging + optional rule-based translation (read-only by default)
  • ai.nl.explain β€” explanation + preview rows for verification
  • ai.nl.execute β€” execution gated by approval token
  • skeindb nl-eval β€” JSONL evaluation harness with exact and execution-match metrics

9. causal.* β€” Causal consistency via ETag chainsΒΆ

Related: R13

  • query.select / query.execute_prepared accept cache.min_causality
  • query results include causality tokens (vector_clock_v2; legacy etag_chain_v1 remains accepted on input)
  • causal.session.begin / causal.session.end (future)

10. edge.* β€” Replay bundles as edge replication primitiveΒΆ

Related: R14

  • maintenance.replay.export β€” export snapshot replay bundles with optional primary-key redaction (none, hash_pk, drop_pk) before checksums/performance metadata are computed
  • edge.bundle.request β€” request bounded WAL slice / replay bundle
  • windows: table + seq bounds + max events
  • redaction: none | hash_pk | drop_pk
  • edge.bundle.apply β€” apply bundle coverage windows to the edge node
  • edge.bundle.status β€” coverage + bounded-staleness routing verdict, including gap detection for disjoint windows

11. schema.* (extensions) β€” Conflict-free schema evolutionΒΆ

Related: R15

  • schema.propose_change β€” propose schema evolution changeset
  • schema.merge_status β€” show divergence, merge plan, and proposed resolution guidance
  • schema.simulate_rollout β€” simulate prepare/mixed/steady-state rollout waves for the current merge plan
  • schema.apply_merge β€” apply merged schema
  • Prototype change ops: add_column (nullable/default support) and add_index (name/column list/unique flag)

12. advisor.* (extensions) β€” Dependency-driven index synthesisΒΆ

Related: R16

  • advisor.index_synthesize β€” propose indexes based on dependency analysis
  • advisor.apply_index β€” apply an index suggestion (in-memory secondary index)
  • advisor.dismiss β€” suppress a suggestion
  • advisor.history β€” list advisor actions

13. migration.* (extensions) β€” Intent inferenceΒΆ

Related: R17

  • migration.intent_report β€” detect idioms (pagination, polling, hierarchy self-joins, recursive CTEs, EXISTS membership, COALESCE defaults)
  • migration.rewrite_preview β€” show suggested SkeinQL migration

Example (intent_report):

{
  "samples": [
    { "query": { "...": "..." }, "args": [] }
  ],
  "limit": 20,
  "window_ms": 60000
}

Example (rewrite_preview):

{
  "samples": [
    { "query": { "...": "..." }, "args": [] }
  ],
  "limit": 10
}

14. replay.* (extensions) β€” Performance replayΒΆ

Related: R18

  • maintenance.replay.export β€” exports data bundles with optional performance profile metadata (lsm_state, cache_warm, and timing).
  • maintenance.replay.import β€” validates both correctness checksums and performance-profile checksums when present.
  • maintenance.replay.run β€” returns performance_report variance deltas for performance-annotated bundles, with replay-run checksum parity over reconstructable snapshot state.

15. wasm.* (extensions) β€” Wasm-native operatorsΒΆ

Related: R19

  • wasm.plan.compile β€” compile plan subset to Wasm (see docs/WASM_OPERATORS.md)
  • wasm.plan.run β€” run compiled plan (sandbox)

16. energy.* β€” Energy-aware schedulingΒΆ

Related: R20

  • energy.policy.set β€” compaction energy policies
  • energy.status β€” current energy signals and scheduling decisions

Important: method shapes are intentionally left high-level in this document. Use the proposal docs to define exact parameter schemas.