Individual skill
crestapps-core-yessql-stores
Skill for the CrestApps.Core.Data.YesSql persistence backend in CrestApps.Core 2.0. Covers AddYesSqlDataStore and AddCoreYesSqlDataStore (IStore, collections, index provider registration, scoped ISession, YesSqlStoreCommitter), YesSqlStoreOptions collection names, per-feature AddYesSqlStores on every feature builder including personas and tool instances, the service-collection store methods for web crawlers, file sources, knowledge objects and ingestion item state, the full index and IndexProvider inventory, creating index tables with the Create*IndexSchemaAsync SchemaBuilder extensions, custom models with DocumentCatalog and CatalogItemIndex, and QueryContext paging. Use it when a host persists CrestApps.Core data with YesSql or troubleshoots missing tables, collections, or uncommitted writes.
plugins/crestapps-core/skills/crestapps-core-yessql-stores/SKILL.md
Source commit d86d04f234b1b2bd8145368a2544490f9d557596
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- Yes
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Instructions only
- Last checked
- Nov 6, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 13
- Repository last updated
- Oct 21, 2026
- License
- MIT
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- agent-skills Repository topic
- ai Repository topic
- ai-agents-framework Repository topic
- dotnet Repository topic
- mcp Repository topic
- mcp-server Repository topic
- orchardcore Repository topic
- data Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Read excerpt
# CrestApps.Core YesSql Stores
You are a CrestApps.Core expert. Generate accurate YesSql persistence code with `CrestApps.Core.Data.YesSql`.
## Rules
- Register `.AddYesSqlDataStore(configuration => configuration.UseSqLite(...))` on the root builder (or `services.AddCoreYesSqlDataStore(...)`). On first resolution it creates the singleton `IStore`, initializes the `AI`, `AIDocs`, `AIMemory` and default collections plus any collection an index provider names, and registers every `IIndexProvider` in DI. It also registers scoped `ISession`, scoped `YesSqlStoreCommitter` as `IStoreCommitter`, and `AddCatalogManagers()`.
- `AddYesSqlStores()` on a feature builder only selects stores and index providers. Without `AddYesSqlDataStore(...)` nothing can resolve `ISession`.
- Register custom `IIndexProvider` implementations before the `IStore` is first resolved, or they are never registered with the store.
- The package does not create index tables. Run the `Create*IndexSchemaAsync` extensions once per database before serving requests (the samples' `InitializeYesSqlSchemaAsync()` is sample code).
- Always pass the resolved `YesSqlStoreOptions` to the schema extensions. They read collection names from it; passing `null` creates the tables in the root collection while the index providers query the `AI` collection.
- `YesSqlStoreCommitter` flushes the scoped `ISession`. Add the MVC, hub or endpoint commit filter, or commit explicitly in background scopes.
## Registration