Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Get Started Free →

Microsoft.Data.Sqlite · dotnet | DecimalAI

Sqlite Adonet

SkillScore17Maintained

sqlite-adonet

Implementation details for the Microsoft.Data.Sqlite ADO.NET provider. Use when changing files under `src/Microsoft.Data.Sqlite.Core/`.

codingby dotnet

Links this skill to your agents and keeps it current with the author’s updates.

Automatic

Coding pack

1 · One-time — install the CLI (docs ↗)

pip install decimalai

2 · Get the skill — writes .claude/skills/sqlite-adonet/SKILL.md

decimalai skills pull sqlite-adonet --out .claude/skills/

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/sqlite-adonet/SKILL.md https://app.decimal.ai/s/sqlite-adonet/SKILL.md

Raw file: /s/sqlite-adonet/SKILL.md ↗ · machine-readable summary at /s/sqlite-adonet.json ↗

In productionGlobal

how this skill behaves on real traffic · last 30 days

No production data for this skill yet — usage numbers appear here once agents start running it.

Anonymized aggregate across every org using this skill — proof from real production use, not a demo.

Does this skill help? · Benchmark: with vs. withoutsign in to run this on your agents

24 test cases from the publisher’s eval.yaml · each run twice on gemini-3.6-flash — with the skill injected, then without · last run 55d ago

Yes — +13% lift-30% tokens0% turns17% of whole cases pass with skill (4/24)

Test case	Without → With	Effect	Δ tokens	Δ turns
case-01	✗→✓	▲ Improved	—	—
case-02	✗→✓	▲ Improved	—	—
case-22	✗→✓	▲ Improved	—	—
case-13	✓→✓	＝ Same ✓	—	—
case-09	✗→✗	＝ Same ✗	—	—

Showing 5 of 24 cases

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 7/30/2026

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

dotnet / efcore

.agents/skills/sqlite-adonet/SKILL.md

View on GitHub ↗

License MITImported 8/2/2026Version v1

Skill contents

SKILL.md

Microsoft.Data.Sqlite

Standalone ADO.NET provider in src/Microsoft.Data.Sqlite.Core/, independent of EF Core. Implements System.Data.Common abstractions.

Notable Implementation Details

Static constructor calls SQLitePCL.Batteries_V2.Init() reflectively
CreateFunction()/CreateAggregate() overloads generated from T4 templates (.tt files)

Illustrative Want to see what sqlite-adonet would put in front of your model? Preview the rendered body and check its trigger phrases — no LLM call, no signup.

Latest benchmark · publisher runVerified

7/27/2026, 20:40 UTC · 24 cases

Lift

+13%

17% vs 4%

Agent turns

0%

1.0 vs 1.0

Tokens

-30%

1,241.75 vs 1,783.38

fail → pass · 3pass → pass · 1fail → fail · 20

Per-case results (24)

Case	Status	Duration (ms)			Turns			Tokens			Tool calls
Case	Status	Without	With	Δ	Without	With	Δ	Without	With	Δ	Without	With	Δ
case-09 Which exact method and class within SQLitePCL does the Microsoft.Data.Sqlite static constructor attempt to invoke when preparing native SQLite bindings?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-23 What code generation technology (.tt files) is used in Microsoft.Data.Sqlite.Core for generating CreateFunction and CreateAggregate overloads?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-01 Can you explain how native library initialization is triggered inside the Microsoft.Data.Sqlite library during startup? Please detail what happens in the static constructor.	fail→pass	—	—	—	—	—	—	—	—	—	—	—	—
case-17 What PRAGMA command is executed on a SQLite database connection to enable Write-Ahead Logging (WAL) mode for higher write concurrency?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-20 Are the `CreateAggregate()` extension/instance methods in `Microsoft.Data.Sqlite` handwritten C# source files or generated using T4 text templates?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-13 When looking at the implementation files for user-defined functions in Microsoft.Data.Sqlite, are the generic overloads written manually or produced by template generation?	pass→pass	—	—	—	—	—	—	—	—	—	—	—	—
case-15 How does the legacy System.Data.SQLite library handle interop calls down to native sqlite3.dll on Windows?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-11 What file extension is used in the `src/Microsoft.Data.Sqlite.Core/` source folder for the code generation templates that produce function and aggregate overloads?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-10 Is Microsoft.Data.Sqlite designed strictly as an internal subsystem for Entity Framework Core's SQLite provider, or can it be used as a standalone ADO.NET driver?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-12 At what point in the runtime execution lifecycle of Microsoft.Data.Sqlite is `SQLitePCL.Batteries_V2.Init()` invoked to prepare native library binaries?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-03 Where in the dotnet/efcore repository source tree is the core implementation of the standalone SQLite ADO.NET provider located? Many developers assume it resides under a unified Entity Framework provider directory like `src/EFCore.Sqlite`.	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-21 Does `SqliteConnection` in `Microsoft.Data.Sqlite` inherit from `DbConnection` or implement a proprietary connection interface?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-06 Why doesn't Microsoft.Data.Sqlite fail with a hard AssemblyLoadException at runtime if a specific SQLitePCL raw battery assembly is missing at build time? How does its static constructor invoke the battery initialization method?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-16 In C applications using native `sqlite3.h`, how does one register a custom scalar function using `sqlite3_create_function_v2`?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-05 Which standard framework abstraction hierarchy in .NET does Microsoft.Data.Sqlite derive its connection, command, and reader implementations from? Developers often wonder if it builds custom interfaces or standard classes.	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-07 In the Microsoft.Data.Sqlite source repository, how are the numerous strongly-typed delegate overloads for `CreateFunction()` generated across different parameter arities?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-08 How does the Microsoft.Data.Sqlite source codebase maintain and generate the wide variety of `CreateAggregate()` method overloads for custom SQL aggregation?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-14 How does Entity Framework Core generate SQLite table migration scripts when running `dotnet ef migrations add InitialCreate` for a DbContext targeting SQLite?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-02 I need a technical summary of how Microsoft.Data.Sqlite implements System.Data.Common abstractions as a standalone ADO.NET provider without depending on EF Core.	fail→pass	—	—	—	—	—	—	—	—	—	—	—	—
case-22 What specific native initialization task is assigned to the static constructor in the `Microsoft.Data.Sqlite` provider codebase?	fail→pass	—	—	—	—	—	—	—	—	—	—	—	—
case-19 When initializing native bindings in `Microsoft.Data.Sqlite`, why does the static constructor use reflection to invoke `SQLitePCL.Batteries_V2.Init()` rather than calling `SQLitePCL.Batteries_V2.Init()` directly as a compiled static method call?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-04 When adding the core Microsoft.Data.Sqlite package to a modern .NET console application, does it require installing Microsoft.EntityFrameworkCore as a dependent package or runtime framework?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-18 What exact relative folder path under the main repository root holds the core project files for `Microsoft.Data.Sqlite`?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—
case-24 Is Entity Framework Core required as a dependency when utilizing Microsoft.Data.Sqlite for basic ADO.NET database operations?	fail→fail	—	—	—	—	—	—	—	—	—	—	—	—

These cases were also screened by the skill’s intent / safety pass.See the Trust review ↗Reproduce this benchmark in Colab ↗

How this skill was measured

DecimalAI ran this skill against gemini-3.6-flash twice over the same eval suite — once with the skill loaded and once without — and compared the two runs case by case. 24 cases were attempted. The headline lift of +13 percentage points is the difference between those two pass rates over the 24 comparable cases.

Model measured: gemini-3.6-flash
Graded by: gemini-3.6-flash
Grading method: judged
Verification: verified
Pass rate without the skill: 4.2%
Pass rate with the skill: 16.7%
Cases attempted: 24
Cases counted toward lift: 24
Cases that regressed: 0
Skill version measured: v1
Run completed: 7/27/2026, 20:40 UTC

The per-case answers from this run were removed by the retention sweep, so the case table below shows the verdicts without the text either arm produced. The counts above were recorded at the time and are unaffected. Answers are now kept for 180 days.

SkillScore blends 4 signals1 of 4 complete

BenchmarkPass rate WITH skill on a verified run17

Live evalNeeds ≥10 evaluated traces in 30 days

AI ratingNeeds ≥10 rated traces

AdoptionNeeds ≥10 serves across ≥2 orgs in 30 days

Efficiency · separate axis (at equal correctness)+0% turns-45% tokens

Shown for transparency; not credited unless a verified run shows no correctness regression.

Backed by 1 of 4 signals — each added signal makes the score more robust.

Verified on gemini-3.6-flash · re-tested 55 days ago

Other measured skills in the registry, with their headline benchmark lift.