Audited Q4 2026 Baseline .NET 11 / EF Core 11 (Nov 2026) · MCP 2026-07-28 RC · Reg (EU) 2026/1744 · OWASP LLM 2026

AI Agent Database Connectivity Benchmark (2026): Drivers, MCP Security, Vector TCO & Runtime Scaling

Independent architectural audit of 12 evaluated stacks across 8 ecosystems (Devart, Open-Source, CData, Fivetran+dbt, Airbyte, Progress DataDirect, Simba, and Snowflake/Databricks/Fabric), scored on 50 non-overlapping criteria using a transparent 2–1–0 traffic-light rubric.

01 · Runtimes (.NET 11)
1 of 6

Only OSS Npgsql ships official SK VectorData; dotConnect 2026.1 leads Day-1 EF Core 11.

02 · Security (CVEs)
CVSS 9.4

CVE-2026-17351 (pgAdmin 4 AI) & 13 archived OSS MCPs expose sqlparse & prompt-only gaps.

03 · RAG Ingestion TCO
0.28M MAR

Break-even of Zero-MAR Devart ODBC (0.94M loaded) vs Fivetran Std ($71.5K–$153.1K/yr @ 50M).

04 · Hybrid SQL+Vector
-$28,620

3-year savings of PostgreSQL halfvec+DiskANN vs Split Pinecone (eliminates $850–$2K/mo Sync Tax).

05 · Rebundling Exit Cost
-74.3%

$71.3K open-protocol migration vs $277.3K warehouse lock-in (5-meter cost stacking).

06 · Swarms & Bloat
-95.6%

DTO/TOON/CSV cuts payload bloat; 50 stdio MCP spawns 5,000 sockets without HTTP pooling.

01 · AGENT RUNTIME
Claude · Cursor · SK · LangChain
Tool Calling & Text-to-SQL
02 · PROTOCOL, POOLING & GUARDRAILS
AST · DB RBAC · In-Driver SSH
95 MB Alpine · Zero-MAR · Pooled
03 · ENTERPRISE DATA & LAKEHOUSE
PG · Oracle 26ai · BigQuery · SaaS
On-Prem Legacy & Vector Engines
EXECUTIVE SUMMARY 2026 Stack Selection Verdict

Selecting an AI agent database connectivity stack in 2026 requires balancing runtime compatibility, Text-to-SQL security, and compounding ingestion fees. For PostgreSQL + Microsoft Semantic Kernel, open-source Npgsql with CommunityToolkit.VectorData.PgVector is the sole official VectorData store, whereas Devart dotConnect 2026.1 leads multi-engine .NET 11 / EF Core 11 breadth in 95 MB Alpine containers using custom [KernelFunction] wrappers. For RAG ingestion and legacy on-prem access, flat-rate Zero-MAR drivers (Devart ODBC / SSIS) reach break-even at just 0.28M–0.94M MAR against metered ELT stacks like Fivetran V.11, while avoiding the $277.3K multi-cloud exit tax of rebundled warehouses. In production, prompt-only and client readonly=True hints fail under CVE-2026-17351: enforce database RBAC, strict AST parsing, bounded schemas, and stateless Streamable HTTP pooling before scaling beyond 10 concurrent agents.

SECTION 01 · ARCHITECTURE LANDSCAPE & RUNTIME VERIFICATION

Master Connectivity Landscape: 12 Evaluated Stacks (Traffic-Light Matrix)

The 2026 agentic data connectivity market splits into three architectural tiers: local or Streamable HTTP MCP servers for IDE and desktop copilots, metered cloud ELT Context Layers for centralized warehouse syncs, and direct managed/wire drivers embedded inside custom .NET, Python, or Delphi agent runtimes. Every cell below is scored on an unbiased 2–1–0 rubric—flagging real gaps and constraints across both commercial vendors and open-source stacks.

Unbiased Traffic-Light Rubric (2–1–0)
2 · PASS / Advantage Verified capability, transparent pricing, or zero lock-in
1 · PARTIAL / Constraint Works with documented caveats (e.g., DB RBAC required, online license check)
0 · GAP / Risk / Quote-Gate Missing runtime support, CVE/archived risk, or sales-gated pricing

Unified Architecture Comparison (12 Evaluated Connectivity Stacks)

Showing 12 of 12 evaluated stacks
Evaluated Stack Direct Mode / Footprint Read-Only & Guardrails CI/CD & Docker Lock-In & Exit Pricing Transparency
Devart ODBC Drivers (92+ Sources) ODBC 3.8 · Python / C++ / Go / ARM64 2 Direct TCP/IP in 155 MB Debian-slim; zero Oracle Instant Client. 1 Read Only=True + In-Driver SSH; still requires DB RBAC against DDL bypass. 1 Subscription edition uses online activation unless upgraded to Site/OEM. 2 Zero-MAR standard SQL-92; no warehouse lock-in. 2 Public: $169.95/yr single · $499.95/yr Universal promo.
Devart dotConnect (.NET 11 / EF11) Managed ADO.NET · BigQuery, MongoDB, Oracle 2 Direct=True managed code on 95 MB Alpine (musl); Day-1 EF Core 11. 1 DbCommandInterceptor + In-Driver SSH; no official SK VectorData package. 2 License Key=...; embedded directly in connection string for ephemeral pods. 2 Standard ADO.NET / EF Core abstractions; portable across clouds. 1 $269.95/yr (DB2 Dev) public; Universal & Server tiers Quote-Only.
Devart MCP Servers (20 Servers) 19+ Free Single-Source + Universal v1.1.0 1 Desktop/IDE MCP backed by local Devart ODBC DSNs (no managed cloud SaaS). 1 Inherits ODBC Read Only=True & SSH; relies on DSN & DB role hardening. 1 Local stdio ideal for IDE; multi-agent swarms need HTTP gateway pooling. 2 Open MCP protocol; direct on-prem/cloud DB access without DWH staging. 2 $0 single-source (+ ODBC) · $99.95/yr or $199.95 Universal.
Devart SSIS Components (50+ Sources) Zero-MAR Batch & CDC RAG Ingestion 1 Requires SQL Server SSIS / Azure-SSIS IR host (not a lightweight container). N/A Batch/CDC ETL pipeline; not an interactive LLM Text-to-SQL runtime. 1 Automated via dtexec.exe & CI/CD; Windows/Azure-SSIS IR bound. 2 Zero-MAR flat-rate; keeps embeddings & data inside private VPC. 2 $209.95/yr single · $499.95/yr Universal Bundle.
Devart Entity Developer Visual ORM, Bounded DbContext & DTO Designer N/A Design-time schema governance & codegen tool (zero runtime overhead). 2 Slices 500-table ERPs into <15-table bounded DbContext & PII-free DTOs. 2 Generates clean C# / EF Core 11 code committed directly to Git. 2 Standard EF Core / NHibernate / Dapper output; zero runtime lock-in. 2 $0 Express (10 entities) · $269.95 Std · $319.95–$389.95 Pro.
Devart SecureBridge & Delphi DACs PgDAC / UniDAC / ODAC / IBDAC · Delphi 13 2 Pure TCP/IP Direct Mode + native TPgVector (no libpq/OCI/OpenSSL DLLs). 2 Embedded SSHv2 / TLS 1.3 (TScSSHClient) eliminates open firewall ports. 2 Compiled native binaries for Win/macOS/Linux; zero external DLL hell. 2 Direct database protocols; perpetual/annual source-available options. 2 Public: SecureBridge $119.95–$359.95 · UniDAC $419.95–$1,079.95.
CData Software (Connect AI & v26.0.x) 350+ SaaS/DBs · Federated Derived Views 1 350+ sources & Derived Views (-97.6% tokens), but no .NET 11/EF11. 0 Entra/Okta SSO & governance gated to Quote-Only Business tier. 0 Node-locked Docker requires sales-gated RTK; Windows .exe installer friction. 1 Derived Views & Connect AI cloud layer create semantic/SaaS coupling. 1 $79–$159/mo Connect AI; $499/yr Dev Driver; Business/RTK Quote-Only.
Fivetran + dbt (Context & ELT V.11) 700+ Cloud ELT Connectors · Agent MCP 0 No direct live-DB driver; requires centralized cloud DWH staging. 2 Strong warehouse RBAC & dbt Semantic Layer (99.1% Text-to-SQL accuracy). 2 Fully managed cloud SaaS + dbt MCP GA; zero local driver packaging. 0 Rebundled 5-meter cost stacking; 12-mo exit cost up to $277.3K. 0 V.11 bills deletes & History MAR ($71.5K–$153.1K/yr @ 50M MAR).
Airbyte (Cloud & ELv2 Core) Credit-Based ELT · Self-Hosted K8s 1 Self-hosted K8s/Docker option, but batch ELT rather than live driver. 1 Relies on destination warehouse RBAC; no native Text-to-SQL AST guardrail. 2 PyAirbyte & Terraform/K8s native deployment for OSS Core. 1 OSS Core portable, though enterprise connectors gated behind ELv2/Cloud. 1 Cheaper than Fivetran, but Sept 2026 doubled overages to $5.00/cr.
Progress DataDirect (HDP 5.0) Enterprise Wire-Protocol · Autonomous REST 2 Mature wire-protocol ODBC/JDBC, ARM64 Linux, and on-prem HDP gateway. 1 Strong Kerberos/TLS; 0 native MCP servers (requires custom wrapper). 1 HDP Docker tarball requires gated enterprise portal provisioning. 2 Standard ODBC/JDBC/OData interfaces; no cloud DWH lock-in. 0 100% Quote-Only pricing across all SKUs; 15-day REST trial only.
Simba / insightsoftware Enterprise ODBC/JDBC & Governed MCP 1 Proven ODBC 3.8 / JDBC 4.2 engines; no .NET 11/EF11 managed Direct Mode. 2 Simba Agentic Intelligence governed single MCP endpoint + RBAC. 0 Gated download forms & manual .lic file distribution in CI/CD. 1 Standard SQL drivers, though Agentic AI hub is proprietary. 0 $2,625/yr Single Desktop · $15,000+/yr Dept · Agentic AI Quote-Only.
Open-Source (Npgsql / CommunityToolkit / MCP) MIT/Apache · Official SK VectorData 2 Only official Semantic Kernel VectorData + Direct Mode (PostgreSQL only). 0 13 OSS reference MCPs archived; legacy 0.6.2 SQL bypass & CVE-2026-17351. 2 Zero license keys; native NuGet/PyPI packages in Alpine & slim containers. 2 100% open standards (MIT/Apache 2.0); zero vendor lock-in. 2 $0 software cost (engineering & security maintenance borne in-house).

Multi-Runtime Capability & .NET Semantic Kernel Verification

Multi-Runtime Capability Radar (Normalized Qualitative Rubric)

0–5 rubric across 6 agentic engineering axes. Shows why no single stack wins everywhere: OSS leads official Semantic Kernel, Devart leads .NET 11 / Zero-MAR / Delphi, and Fivetran leads cloud SaaS connector breadth.

Normalized Qualitative Rubric (0–5): Derived from Q4 2026 capability verification (Semantic Kernel VectorData registry, EF Core 11 release notes, MCP 2026-07-28 RC spec, and public SKU docs).

.NET Provider Direct Mode .NET 11 / EF11 Official SK VectorData
Npgsql + CommunityToolkit.PgVector Yes Yes 1 of 6Replaces deprecated SK.Connectors.PgVector (#13675).
Devart dotConnect 2026.1 Yes Day-1BigQuery, MongoDB, Oracle 23ai/26ai, JSON updates. CustomRequires custom [KernelFunction] plugin wrapper.
Microsoft.Data.SqlClient 7.0 TDS PartialEF11 RRF vector bug requires 2 queries in C#. PreviewCommunityToolkit SQL Server connector.
Oracle.ManagedDataAccess.Core Thin LaggingEF Core 11 cadence trails Day-1 releases. NoneNo official SK VectorData provider.
CData ADO.NET Providers Mixed No EF11 None
Progress DataDirect ADO.NET Wire No EF11 None

Key .NET 11 & Semantic Kernel Audit Finding

Only 1 of 6 evaluated .NET stacks (Npgsql + CommunityToolkit.VectorData.PgVector) satisfies all three conditions for an official Microsoft Semantic Kernel VectorData store in Q4 2026. Meanwhile, Devart dotConnect 2026.1 leads multi-engine .NET 11 / EF Core 11 breadth—shipping Day-1 support for JsonPathExists, JsonContains, FullJoin, Oracle 23ai/26ai sparse/dense vectors, and new dotConnect for Google BigQuery and MongoDB—requiring lightweight [KernelFunction] wrappers for SK tool calling.

SECTION 02 · ECOSYSTEM SHIFTS, PRICING TRANSPARENCY & PAYWALL AUDIT

Ecosystem Shifts, Pricing Transparency & Enterprise Paywall Audit

Between late 2025 and Q4 2026, four structural shifts altered agentic data budgets: open-source reference MCP deprecation, .NET 11 / EF Core 11 runtime divergence, metered ELT price hikes, and ARM64/Universal MCP releases. Meanwhile, hidden Quote-Only gates for SSO and Docker Runtime Keys remain the primary procurement bottleneck.

Four Breaking 2025–2026 Shifts Reshaping 2026 Blueprints

Shift 1 · OSS MCP

13 Reference MCPs Archived

13 official reference MCP servers were archived; legacy mcp-server-postgres 0.6.2 retains a documented read-only SQL bypass, forcing teams toward hardened drivers or audited gateways.

Shift 2 · .NET 11

SK Migration & EF Core 11

Microsoft Semantic Kernel moved to CommunityToolkit.VectorData.PgVector (1 of 6 verified), while .NET 11 / EF Core 11 (Nov 2026) added JSON partial updates and FULL JOIN.

Shift 3 · Cloud ELT

Fivetran V.11 & Airbyte $5/cr

Fivetran V.11 (Nov 1, 2026) bills source deletes and History Mode MAR; Airbyte (Sept 2026) doubled overage credits to $5.00/cr—accelerating Zero-MAR adoption for RAG chunking.

Shift 4 · Direct Drivers

MCP Universal v1.1.0 & ARM64

MCP Server Universal v1.1.0 shipped at $99.95/yr ($199.95 perpetual) alongside Linux ARM64 ODBC builds and Day-1 dotConnect providers for BigQuery and MongoDB.

Published Entry Costs vs. Enterprise Quote Gates

Published Annual Entry Cost by Stack (USD, Log Scale)

Compares minimum publicly disclosed annual entry SKU. Note: Quote-Only enterprise tiers (Progress DataDirect, CData Business/RTK, Simba Agentic AI) are excluded from numeric bars and flagged in the ledger below.

Baseline (Q4 2026): Devart MCP Single-Source is $0 (requires licensed ODBC after 30-day trial, from $169.95/yr); Fivetran paid floor is $12,000/yr (Free ≤500K MAR).

Market Pricing Transparency Breakdown (12 Evaluated Stacks)

Share of evaluated stacks offering transparent self-serve SKUs versus conditional trial-to-paid or opaque Quote-Only enterprise gates.

Audit Criterion: Green = fixed public pricing for production; Amber = public entry tier with paid/quote-only upper features; Red = 100% Quote-Only or key enterprise security/Docker gated.

Interactive 2026 SKU, Trial & Paywall Ledger

Full SKU-level audit of entry pricing, trial windows (14–60 days), and hidden paywalls (SSO, Docker Runtime Keys, or department-level minimums).

Showing 10 of 10 SKU rows
Vendor & Product Line Published Entry / Tier Pricing Trial / Guarantee Transparency & Paywall Audit
Devart ODBC Drivers (92+ Sources) Devart · ODBC 3.8 $169.95/yr single · $499.95/yr Universal promo 30-day free trial 2 · Public Fixed Self-serve checkout; Subscription Docker requires online check unless Site/OEM.
Devart MCP Servers (19+ Single & Universal) Devart · MCP v1.1.0 $0 Single-Source · $99.95/yr ($199.95 perp.) Universal 30-day free trial 1 · Dependency MCP Server binary is $0, but requires licensed Devart ODBC driver after 30-day trial.
Devart dotConnect & Entity Developer Devart · .NET 11 / EF11 $269.95/yr (DB2 Dev) · Entity Dev $0 / $269.95–$389.95 30-day trial / money-back 1 · Split Tiers Dev & Entity Developer prices public; Universal/Server dotConnect tiers Quote-Only.
Devart SSIS Components & Delphi DACs Devart · SSIS / SecureBridge / UniDAC SSIS $209.95–$499.95/yr · SecureBridge $119.95+ · UniDAC $419.95+ 30-day trial / 60-day MBG 2 · Public Fixed Transparent public pricing across Dev, Pro, and Bundle tiers (SSIS Server Quote-Only).
CData Connect AI & v26.0.x Drivers CData · Federated MCP / Drivers Connect AI $79–$159/mo (annual) · Dev Driver $499/yr 14-day (Connect AI) / 30-day (Drivers) 0 · Paywall Gate Entra/Okta SSO gated to Quote-Only Business tier; Docker Runtime Key (RTK) sales-gated.
Progress DataDirect (HDP 5.0 & REST) DataDirect · Enterprise Wire 100% Quote-Only (Not publicly disclosed) 15-day (Autonomous REST ODBC) 0 · Opaque Pricing No public SKUs; HDP Docker tarball and enterprise licensing require sales engagement.
Fivetran + dbt (Context & ELT V.11) Fivetran · Metered MAR $0 Free (≤500K MAR) · Paid floor $12,000/yr 14-day account + 14-day/connector 0 · MAR Escalation V.11 (Nov 2026) bills deletes & History Mode; 50M MAR hits $71.5K–$153.1K/yr.
Airbyte (Cloud Credits & ELv2 Core) Airbyte · Credit ELT $0 OSS Core · Cloud $20/mo Std + $5/cr · Plus $189/mo 14-day Cloud trial 1 · Credit Overages Transparent base tiers, but Sept 2026 doubled extra credits to $5.00/cr.
Simba / Magnitude (insightsoftware) Simba · Enterprise ODBC/MCP $2,625/yr Single Desktop · $15,000+/yr Dept · AI Quote-Only Gated forms (Promo to Dec 31, 2026) 0 · High Floor / Gated $2,625/yr entry for single desktop; Agentic Intelligence and .lic builds gated.
Open-Source (Npgsql / CommunityToolkit / MCP) OSS · MIT / Apache 2.0 $0 software license Always Free 2 · Zero License Fee No license paywalls; engineering & CVE patching costs borne internally.
SECTION 03 · RAG INGESTION TCO, MAR & CLOUD EGRESS ECONOMICS

RAG Ingestion TCO: Metered Cloud MAR vs. Flat-Rate Zero-MAR

Agentic RAG workloads behave differently from traditional BI dashboards: frequent document re-chunking, embedding model upgrades, GDPR delete cascades, and 429 API retries multiply Monthly Active Rows (MAR) and inflate metered cloud ELT bills by 2.64× to 44.9× compared to flat-rate Zero-MAR drivers.

Interactive 5-Source RAG Ingestion TCO Simulator (1M–50M MAR)

RAG Re-Chunk Churn:
Horizon:
Devart ODBC (5-Source Linux)
$5,856 / yr

Loaded ($1,989/yr cash license + AWS compute). Flat Zero-MAR across 1M–50M rows.

Fivetran Standard @ 50M MAR
$71,589 / yr

5-connector metered MAR (V.11 bills deletes & History Mode). Up to $153.1K/yr on BC.

Net Savings (ODBC vs. Fivetran Std)
$65,733 / yr

91.8% lower 5-source ingestion TCO at 50M MAR (1.0× churn).

5-Source RAG Ingestion TCO Across 1M–50M MAR (USD)

Compares Fivetran Business Critical, Enterprise, and Standard against Airbyte Cloud Plus, Devart SSIS Loaded Floor, and Devart ODBC Loaded (Linux). Toggle Churn and Horizon above to update curves.

Baseline (Q4 2026): Devart ODBC 5-source cash license is $1,989/yr ($5,856/yr loaded with AWS worker compute); 3-Yr loaded = $17,831. Devart SSIS loaded floor = $9,272/yr (3-Yr = $27,815).

Zero-MAR Break-Even Thresholds & Cloud Egress Multipliers

Zero-MAR Break-Even Threshold (Millions of MAR)

Monthly Active Rows required for flat-rate Devart ODBC/SSIS to pay for itself against metered Fivetran and Airbyte Cloud Standard (7 cr/M).

Takeaway: Devart ODBC breaks even at 0.13M–0.32M MAR cash (0.44M–0.98M MAR loaded) vs. Fivetran, and 4.88M–14.09M MAR vs. Airbyte.

AWS US-East Annual Network Egress Tax (0.6–60 TB/yr)

Hidden cloud networking costs when RAG workers and vector databases sit across NAT Gateways, Cross-AZ, PrivateLink, or Same-AZ Private IPs.

Topology Rule: Co-locating direct drivers in the Same-AZ Private IP eliminates up to $8,381/yr in NAT + Egress taxes at 5,000 GB/mo.

5-Source RAG Ingestion Stack Billing Model 1M MAR / yr 50M MAR / yr (1.0×) 3-Year TCO @ 50M MAR
Devart ODBC Drivers (5-Source Linux) Zero-MAR Direct SQL-92 2 · Flat Zero-MAR $1,989/yr cash · $5,856/yr loaded $5,856 $5,856 $17,831 ($6,231 cash)
Devart SSIS Components (Floor) Zero-MAR Batch / CDC 2 · Flat Zero-MAR $5,405/yr cash · $9,272/yr loaded $9,272 $9,272 $27,815
Airbyte Cloud Plus Credit-Based ELT (Sept 2026) 1 · Credit Overage $189/mo base + $5.00/cr $2,268 $17,988 ($33,588 @ 2.0×) $53,964–$100,764
Fivetran Standard (5 Connectors) Metered MAR (V.11) 0 · Metered MAR Bills source deletes & History Mode $6,240 $71,589 ($89,596 @ 2.0×) $214,767–$268,788
Fivetran Enterprise (5 Connectors) Metered MAR (V.11) 0 · Metered MAR Enterprise SLA & RBAC tier $8,240 $95,581 ($119,633 @ 2.0×) $286,743–$358,899
Fivetran Business Critical (5 Connectors) Metered MAR (V.11) 0 · Metered MAR PrivateLink / HIPAA / PCI tier $12,388 $153,163 ($191,722 @ 2.0×) $459,489–$575,166
SECTION 04 · DATA STACK REBUNDLING, COST STACKING & MULTI-CLOUD EXIT COST

Data Stack Rebundling (2026), Cost Stacking & Multi-Cloud Exit Cost

The "Rebundling Paradox": unified platforms—Fivetran + dbt Labs (merged June 1, 2026), Snowflake Openflow + Cortex, Databricks Lakeflow + Genie, and Microsoft Fabric OneLake—accelerate single-cloud prototyping, but stack up to five compounding billing meters and create a $277.3K multi-cloud migration wall.

Rebundled vs. Decoupled Architecture & Lock-In Matrix (10 Platforms)

Platform Storage / Semantic Lock-In Orchestration Coupling On-Prem Legacy Reach MCP / AI Maturity (Q4 2026) Cost Predictability Telemetry Portability Exit Friction
Devart Connectivity + Open Iceberg/MCP Decoupled Zero-MAR 2None (direct SQL/Iceberg) 2Any Python/.NET/K8s 2Oracle, Firebird, SAP, DB2 120 MCPs; Universal $99.95/yr 2Flat-rate Zero-MAR 2OpenTelemetry / local logs 2Low (-74.3% exit cost)
Progress DataDirect HDP 5.0 Decoupled Wire Gateway 2Standard ODBC/OData 2Agnostic REST/SQL 2Strong behind firewall 00 native MCP servers 0100% Quote-Only 1HDP gateway logs 2Low (standard wire SQL)
CData Connect AI & Drivers Federated MCP / Derived Views 1Derived Views coupling 1Connect AI cloud layer 1Cloud-first SaaS focus 2Mature hosted MCP 1Business SSO Quote-Only 1Connect AI audit UI 1Moderate (view rewrite)
Fivetran + dbt Labs Rebundled ELT + Semantic 1Target DWH + dbt YAML 0Tightly coupled ELT+dbt 1HVR agent required 2dbt MCP GA + Context 05-meter MAR stacking 1Fivetran Log / dbt artifacts 0High ($277.3K exit)
Snowflake Openflow + Cortex Rebundled Cloud DWH 0Proprietary Cortex & DWH 036-mo Oracle XStream lock 1Openflow BYOC runtime 2Cortex Analyst / Search 0AI Credits token bloat 1ACCESS_HISTORY 45m–3h lag 0Very High (contract + rewrite)
Databricks Lakeflow + Genie Rebundled Lakehouse 1Unity Catalog / Delta 0Lakeflow jobs & DLT 1Limited legacy reach 1Free Genie ends Jan 31, 2027 0DBU + serverless stacking 1Unity System Tables 0High (Unity/DLT rewrite)
Microsoft Fabric OneLake Rebundled Azure SaaS 0OneLake / Power BI tenant 057/86 connectors preview 1On-prem data gateway 125×25 table/col cap 1F-SKU capacity tiers 1Azure Monitor / Purview 0High (tenant coupling)
Airbyte Cloud + PyAirbyte Decoupled Credit ELT 2Writes to any target DB 2Terraform / K8s portable 1Self-hosted VPC workers 1PyAirbyte RAG loaders 1$5.00/cr overage hike 2Open sync logs 2Low (ELv2 core)
Simba / insightsoftware Enterprise ODBC/JDBC + AI 2Direct wire SQL 2BI / Python / Java agnostic 2Broad enterprise DBs 1Agentic AI Quote-Only 0$2,625–$15K+/yr gated 1Proprietary AI hub logs 2Low (standard SQL)
Open-Source (Npgsql / DuckDB / Iceberg) 100% Open Stack 2Zero storage lock-in 2Full code ownership 0Weak for SAP/Firebird/DB2 113 ref MCPs archived 2$0 license 2Full OpenTelemetry 2Minimal

Compound Cost Stacking & Cortex Token Bloat

Monthly 5-Meter Cost Stacking @ 20M MAR (USD/mo)

Rebundled cloud platforms layer Ingestion, Transformation, Warehouse Compute, and AI Inference into a $12,650/mo bill versus $173/mo for a decoupled Zero-MAR driver stack.

Breakdown: Rebundled stack = Ingestion ($4,800) + Transform/dbt ($2,150) + Cloud DWH Compute ($3,200) + AI Inference Credits ($2,500) vs. Devart Zero-MAR Driver License ($173/mo).

Cortex AI Credit Burn by Context Window (15k → 100k Tokens)

Multi-turn agentic SQL dialogs compound token consumption—comparing Global ($2.00/credit) vs. Regional ($2.20/credit) inference pricing.

Why It Matters: Unbounded schema dumps push agent conversations toward 100k tokens, multiplying per-turn cloud AI inference spend.

Multi-Dimensional Portability, AI Readiness & 12-Month Exit Cost Modeling

Architectural Portability Radar (Qualitative Rubric)

0–5 qualitative comparison of Devart + Iceberg + MCP against Databricks Lakeflow and Snowflake Openflow.

Normalized Qualitative Rubric (0–5): Evaluates format openness, multi-cloud portability, on-prem legacy reach, and contract exit flexibility.

2026 Industry AI Readiness vs. Production Reality (%)

High developer AI adoption does not equal reliable Text-to-SQL in production without strict schema contracts.

Sources: JetBrains Developer Ecosystem Survey 2026 (28,945 devs: 90% weekly / 68% daily), Gartner (17% in production), and Spider2-style strict schema benchmarks (4.95% completion without strict specs).

10-Source Stack Exit Engineering Hours

Engineering hours required to migrate a 10-source agentic data stack off a rebundled warehouse (Scenario A) vs. open protocols (Scenario B).

Delta: 1,680 hrs (Scenario A Gap) vs. 480 hrs (Scenario B Pass) — a 71.4% reduction in migration engineering time.

12-Month Multi-Cloud Exit Cost (USD)

Total 12-month exit cost including engineering labor and $25,000 stranded proprietary artifacts in Scenario A.

Result: Scenario B ($71,325) cuts exit cost by -74.3% compared to Scenario A ($277,300 incl. $25K stranded cost).

SECTION 05 · HYBRID SQL+VECTOR ECONOMICS & .NET 11 / PYTHON / DELPHI DRIVERS

Unified Hybrid SQL+Vector vs. Dedicated Vector DBs & .NET 11 / Python / Delphi Drivers

Storing embeddings inside relational or document databases eliminates the $850–$2,000/mo CDC Sync Tax and stale-ACL drift of split vector architectures, saving up to $28,620 over 3 years. Still, engineering limits matter: pgvector caps HNSW float32 at 2,000d (4,000d for halfvec), Oracle 26ai HNSW does not run on RAC (requiring IVF), and SQL Server 2025 DiskANN remains preview on-prem.

Unified Hybrid vs. Split Vector Engines (Quantization & 3-Year Sync Tax)

Vector Scale (1536-dim):
Showing 100M vectors (1536-dim): 798 GB float32 → 24.96 GB binary

Vector Index RAM Footprint by Quantization (GB)

32× memory compression from float32 (798 GB @ 100M) down to halfvec, int8, and Binary (24.96 GB @ 100M).

Scale Impact: halfvec cuts RAM by 50% and unlocks 4,000d HNSW indexing in pgvector.

Monthly TCO Decomposition: Hybrid vs. Split Stack (USD/mo)

Breaks down DB Infra, CDC Sync pipelines, 2nd-Service Ops, and Stale-ACL Governance Risk—exposing the $850–$2,000/mo Sync Tax on split stacks.

Why Hybrid Wins: Unified SQL+Vector has $0 CDC Sync cost and enforces row-level ACLs inside a single ACID transaction.

3-Year Cumulative TCO Trajectory (USD)

36-month cost curve comparing Hybrid PostgreSQL (halfvec + DiskANN) against Split PostgreSQL + Pinecone Standard.

3-Year Savings: $20,900–$28,620 saved by keeping SQL and vectors in one engine at 10M–100M scale.

Query Latency Honesty Check: Dedicated Vector DBs vs. pgvector (ms)

Where dedicated vector databases legitimately lead: ultra-low-latency ANN search at 10M+ vectors without manual partitioning.

Honest Tradeoff: Qdrant (8–12 ms p99), Weaviate (16 ms), and Pinecone (18 ms) outperform unpartitioned pgvector (80–140 ms p95).

Showing 8 of 8 vector engines
Vector Engine Architecture Index & Dimension Limits Latency / Online Fit Sync Tax & ACL Risk
PostgreSQL (pgvector + pgvectorscale)Unified Hybrid SQL+Vector 2 · Single EngineACID SQL + DiskANN + halfvec 1 · 2,000d / 4,000dfloat32 max 2,000d; halfvec 4,000d 1 · 80–140 ms p95Needs partitioning at 10M+ 2 · $0 Sync TaxNative PG RLS & ACID joins
Oracle Database 23ai / 26aiUnified Hybrid SQL+Vector 2 · Single EngineNative VECTOR + sparse/dense 1 · RAC ConstraintHNSW not supported on RAC → use IVF 2 · EnterpriseIn-memory neighbor graph 2 · $0 Sync TaxOracle VPD / RBAC enforced
SQL Server 2025 / Azure SQLUnified Hybrid SQL+Vector 2 · Single EngineNative VECTOR + T-SQL 1 · Preview On-PremDiskANN on-prem still preview 1 · EF11 RRF BugSqlClient 7.0 needs 2 queries 2 · $0 Sync TaxNative SQL Server security
MongoDB 8.2+ Atlas / EnterpriseUnified Document+Vector 2 · Single EngineJSON docs + Atlas Vector Search 2 · QuantizedScalar/binary quantization 2 · Low LatencyDedicated search nodes 2 · $0 External CDCUnified document ACLs
Google BigQuery Vector SearchCloud DWH Batch Vector 1 · Batch DWHIVF / TreeAH over warehouse 2 · Petabyte ScaleNo local RAM ceiling 0 · $6.25/TiBToo slow/costly for <20 ms online 2 · IAM / VPCZero external vector sync
Qdrant (Cloud / Self-Hosted)Dedicated Vector DB 1 · Split StackRequires separate SQL DB 2 · Binary/PQRust HNSW + payload filters 2 · 8–12 ms p99Fastest 10M+ ANN benchmark 0 · Sync TaxRequires CDC + ACL replication
WeaviateDedicated Vector DB 1 · Split StackRequires separate SQL DB 2 · Multi-TenantBQ/PQ compression + BM25 2 · 16 ms p99Strong hybrid BM25 + dense 0 · Sync Tax2nd-service ops & CDC drift
Pinecone StandardDedicated Vector DB 1 · Split StackManaged serverless only 2 · ManagedZero index tuning 2 · 18 ms p99Consistent managed SLA 0 · +$28.6K (3-Yr)$850–$2K/mo Sync Tax + lock-in

.NET 11 / EF Core 11, Python (psycopg3/ADBC/ODBC) & Delphi (FireDAC vs. PgDAC)

.NET 11 Runtime Async Overhead Reduction (ns)

Released November 10, 2026: .NET 11 Runtime Async cuts async await overhead by 53.9% (254 ns → 117 ns), directly accelerating high-concurrency database tool-calling loops.

Driver Impact: Only managed .NET 11 providers (Npgsql, Devart dotConnect 2026.1) capture full Runtime Async gains without P/Invoke marshaling penalties.

Language / Driver Status Verified Capabilities & Caveats
.NET 11 · Npgsql + Pgvector.EF 2 · Day-1 + SKOfficial SK store Official SK VectorData + Day-1 EF Core 11 (PostgreSQL only).
.NET 11 · Devart dotConnect 2026.1 2 · Day-1 EF11Multi-engine Day-1 EF11 (JsonPathExists, JsonContains, FullJoin, TPT/TPC JSON) + new BigQuery & MongoDB (MongoDB ships Win client libs).
.NET 11 · SqlClient 7.0 1 · RRF Bug2-query workaround EF11 RRF vector bug requires splitting into 2 queries in C#.
.NET 11 · CData & DataDirect ADO.NET 0 · Legacy .NETNo EF11 / vectors No .NET 11, no EF Core 11, no native vector types.
Python · psycopg3 / Arrow ADBC 2 · Native Vector206k rows/s Arrow ADBC hits 206k rows/s; psycopg3 supports binary PG vectors.
Python · Devart ODBC / Connectors 1 · UnbenchmarkedSQL 2025 / Ora 26ai Python 3.15, SQL 2025 & Oracle 26ai ready; no public vector throughput benchmark vs psycopg3.
Delphi 13.2 · Devart PgDAC / UniDAC 2 · Direct + VectorZero DLLs Pure TCP/IP Direct Mode + native TPgVector; zero client DLLs.
Delphi 13.2 · Embarcadero FireDAC 0 · DLL + No VectorClient-bound Requires external libpq/OCI DLLs; no native VECTOR wrapper.
SECTION 06 · CONTAINER FOOTPRINT, SERVERLESS COLD STARTS & CI/CD FRICTION

Container Footprint, Serverless Cold Starts & Headless CI/CD Friction

Microservice AI agents deployed on Kubernetes or AWS Lambda face two infrastructure penalties: bloated native client libraries (such as Oracle Instant Client triggering DPI-1047 errors across musl vs. glibc mismatches) and AWS Lambda's billable INIT phase (effective August 2025), which turns slow driver initialization into recurring compute spend.

Docker Image Size & Cold-Start Latency Benchmarks

Docker Image Footprint: Compressed vs. Uncompressed (MB)

Managed .NET Alpine Direct=true (42 / 95 MB Pass) and Python 3.12-slim + Devart ODBC (60 / 155 MB Pass) eliminate the 382.3–850 MB Instant Client bloat.

Verified Base Images vs. Architectural Estimate: Base images aspnet:8.0-alpine (95 MB uncompressed), python:3.12-slim (41–45 MB compressed), and python-3.12-cx_oracle (382.3 MB compressed) are verified; combined driver footprints are architectural estimates.

Serverless Lambda Cold Start (ms) & Annual INIT Cost @ 500k/mo

Compares initialization latency (ms) and estimated annual AWS Lambda INIT phase cost at 500,000 cold invocations/month.

Architectural Estimate: .NET Alpine Direct=true (SnapStart/AOT: 250 ms / $25/yr) vs. Python 3.12-slim + ODBC (420 ms / $42/yr) vs. legacy Instant Client (2,800 ms / $280/yr).

CI/CD Activation & Ephemeral Kubernetes Friction Matrix

DevOps Activation Friction vs. Enterprise Governance

Plots deployment friction (1 = zero-touch env var, 10 = sales-gated runtime key or manual .lic file) against audit/governance readiness (Normalized Qualitative Rubric).

Normalized Qualitative Rubric: Ideal ephemeral Kubernetes zone is bottom-right (low CI/CD friction, high governance).

Vendor / Stack Activation Mechanics Ephemeral K8s / CI/CD Fit
Open-Source (Npgsql / psycopg3 / OSS MCP) 2 · Zero KeysMIT / Apache 2.0 Zero activation friction in immutable containers; no license server required.
Devart dotConnect (.NET 11 / EF11) 2 · Conn StringLicense Key=...; Embeds license key directly in connection string / secret env var for ephemeral pods.
Devart Subscription ODBC 1 · Online CheckSite/OEM for offline Standard subscription performs online activation check unless upgraded to Site/OEM.
Progress DataDirect HDP 5.0 1 · Gated TarballEnterprise portal Docker tarball requires gated enterprise portal download & manual artifact mirroring.
CData Software (Drivers & Containers) 0 · Node-LockedSales-gated RTK Standard licenses are node-locked; ephemeral Docker requires sales-gated Runtime Key (RTK).
Simba / insightsoftware 0 · Gated .licManual web forms Gated download forms and manual .lic file mounting slow down automated CI/CD.
SECTION 07 · TEXT-TO-SQL SECURITY, GUARDRAILS & BOUNDED SCHEMAS

Enterprise Text-to-SQL Security, Read-Only Guardrails & Bounded Schemas

System prompts, pyodbc readonly=True (SQL_ATTR_ACCESS_MODE), and ApplicationIntent=ReadOnly are advisory hints—not security boundaries. The CVE-2026-12045 and CVE-2026-17351 (CVSS 9.4 Critical) chain in pgAdmin 4 AI Assistant demonstrated how naive sqlparse filters can be bypassed to achieve remote code execution via COPY ... TO PROGRAM.

Read-Only Enforcement & SQL AST Parser Reliability

Defense-in-Depth Read-Only Enforcement Rating (Qualitative Rubric)

Compares enforcement layers from fragile prompt-only rules up to database-kernel RBAC and read-only standby replicas.

Normalized Qualitative Rubric (0–10): Driver flags (Read Only=True) block accidental mutations at the client boundary, but production requires AST + prepare_threshold=0 + DB Kernel RBAC.

SQL AST Parser Coverage Across Dialects (%)

Verified parse success across PostgreSQL (132), Snowflake (455), and T-SQL (290) test suites. Beware sqlglot lenient mode falling back to generic Command nodes.

Performance Note: Rust-accelerated sqlglot[rs] parses in 0.44 ms, while GSP 4.2.13 leads strict multi-dialect coverage (96%–100%).

Database / Driver Mechanism Enforcement Tier Real-World Security Behavior & Caveats
PostgreSQL NOINHERIT + Read-Only Standby 2 · Kernel-Enforced True kernel-level immutability; avoid pg_read_all_data if PII tables must remain hidden.
Oracle 23ai / 26ai READ ONLY User 2 · Kernel-Enforced Dedicated least-privilege read-only schema user + VPD row policies.
Firebird isc_tpb_read Transaction 2 · Kernel-Enforced Engine-level read-only transaction parameter block rejects writes before execution.
Devart ODBC Read Only=True / Salesforce SOQL 1 · Client Boundary Blocks writes at driver layer (and uses native SOQL mode for Salesforce); pair with DB RBAC.
.NET IFunctionInvocationFilter + DbCommandInterceptor 2 · Defense-in-Depth Intercepts EF Core / Semantic Kernel SQL and enforces SET TRANSACTION READ ONLY.
pyodbc readonly=True / ApplicationIntent=ReadOnly 0 · Advisory Hint Driver/routing hint only; does not stop DDL or RCE payloads (COPY ... TO PROGRAM).

Bounded Schema Compression, Zero-Trust Tunnels & OWASP 2026

Schema Token Compression vs. Strict Recall (Spider2-Snow)

Bounded schema linking (EviLink, arXiv:2605.29670) cuts prompt tokens from 1,991.1K to 116.5K (-94.1% vs. full schema; -79.9% vs. baseline) while raising recall to 93.04%.

Source: arXiv:2605.29670 (EviLink) on Spider2-Snow benchmark.

Text-to-SQL Execution Accuracy by Schema Layer (%)

Raw database schemas yield 64.5% accuracy; adding Graph-Link raises it to 80.3%, and curated Semantic Layers (dbt) reach 99.1%.

Architectural Practice: Use Devart Entity Developer to slice 500-table ERPs into bounded domain DbContexts (<10–20 tables) and PII-free DTOs.

Zero-Trust Tunneling: Attack Surface Reduction vs. Simplicity

Compares exposed DB ports (5432/1433 Gap) and PHP/SSH sidecars (Partial) against In-Driver SSH, SecureBridge TLS 1.3, and PrivateLink (Pass).

Normalized Qualitative Rubric: Top-right quadrant maximizes both attack surface reduction and operational simplicity.

OWASP Top 10 for LLM Applications: 2025 → 2026 Rank Shift

Positive deltas show risks rising in urgency: LLM06 Unbounded Consumption (+4) and LLM03 Excessive Agency (+3).

2026 Watchlist: LLM08 Hidden Context Exposure highlights the risk of leaking full database schemas or PII columns into LLM context windows.

SECTION 08 · MULTI-AGENT CONCURRENCY, TOKEN BLOAT & MCP 2026-07-28 RC

Multi-Agent Runtime Concurrency, Token Bloat & MCP 2026-07-28 RC Write Governance

When teams scale from a single IDE copilot to 10–50 parallel subagents, naive stdio MCP architectures open 1,000–5,000 sockets and exhaust database connection pools and SaaS API rate limits before the LLM finishes its first reasoning turn.

Connection Pool Exhaustion & SaaS Rate-Limit Storms (10–50 Subagents)

Socket & Connection Pool Explosion (Log Scale)

Compares NetSuite (20 slots), PgBouncer (40), and PostgreSQL max_connections (100) against 10–50 stdio MCP subagents spawning 1,000–5,000 sockets.

Fix: Replace per-agent stdio processes with a centralized Streamable HTTP gateway backed by PgBouncer 1.21+, Oracle DRCP, or ADO.NET pooling.

Multi-Agent SaaS API Burst vs. Vendor Quotas (req / 10s)

A 50-agent burst (250 req/10s; 4,800 req/hr) breaches HubSpot (100–190 req/10s burst, 5 req/s search) and NetSuite (5–20 concurrent slots).

Mitigation: Cache SaaS objects locally in SQL/PostgreSQL via Devart ODBC/SSIS or CData Derived Views instead of hitting live CRM search APIs per subagent.

Showing 6 of 6 concurrency mechanisms
Pooler / Mitigation Layer Scale Capacity Production Behavior & Caveats
PgBouncer 1.21+ (Transaction Pooling) 2 · Multiplexed Supports SET LOCAL & prepared statements (v1.21.0+); collapses thousands of agent clients into ~40 DB slots.
Oracle DRCP (Database Resident Pool) 2 · 1 GB vs 42 GB Uses ~1 GB RAM at 5,000 clients compared to 42 GB for dedicated server processes.
ADO.NET / Devart dotConnect Pool 1 · Gateway Only Max Pool Size excels inside a unified HTTP gateway, but fails if each stdio agent spawns its own process.
Devart ODBC / SSIS Local SQL Cache 2 · Zero Rate-Limit Syncs Salesforce/HubSpot/NetSuite into local SQL/Postgres on a flat Zero-MAR license; subagents query locally.
CData Connect AI Derived Views 2 · -97.6% Tokens Pre-joins cross-system SaaS objects and caches query results in Postgres to shield upstream APIs.
Fivetran Context Layer 1 · MAR Cost Eliminates live SaaS rate-limit storms via warehouse sync, but incurs metered MAR charges on every refresh.

Payload Serialization Token Bloat & Schema Discovery Compression

Payload Sizing Math: Raw JSON vs. DTO / TOON / CSV (Bytes)

Raw SELECT * JSON has just 4.0% data density (8,461 B for 336 B of actual data Gap). Flat DTOs cut size by -92.1% (672 B), and TOON / RFC 4180 CSV by -95.0% / -95.6% (Pass).

Token Math: Replacing verbose JSON key repetition with flat DTOs or RFC 4180 CSV cuts LLM input token spend by 12×–22× per tool call.

Schema Discovery: Full Dump vs. Filtered Signature (KB)

Dumping raw information_schema consumes 961.2 KB (938.7 KiB Gap) versus a filtered 3-table signature at 233 B (-99.98% Pass).

Best Practice: Never expose full information_schema to agent discovery; serve only domain-scoped table signatures.

Stateful → Stateless MCP (2026-07-28 RC), HitL Rollbacks & EU AI Act Readiness

All 3 governance tabs rendered SSR in DOM

MCP 2026-07-28 RC: Stateless Streamable HTTP & ToolAnnotations Trap

The 2026-07-28 RC specification shifts production MCP servers from stateful stdio to Stateless Streamable HTTP (removing mandatory Mcp-Session-Id stickiness, introducing Mcp-Method headers, OAuth 2.1 + RFC 8707 + CIMD, and SEP-414 W3C Trace Context propagation). Crucially, MCP ToolAnnotations (readOnlyHint, destructiveHint) are UI hints only Gap—never rely on them for write-protection enforcement.

7 Rules for 2026 Multi-Agent Production Readiness

0 / 7 Verified
SECTION 09 · 100-POINT SCORECARD, WORKLOAD ADVISOR & PRODUCTION FAQ

2026 Ecosystem Verdicts, 100-Point Scorecard & Engineering FAQ

Every score below is aggregated on the server from 50 non-overlapping audited criteria across Sections 01–08 (2, 1, 0 = 100 points max). Click any chapter row to inspect all underlying criteria, or switch Workload Weight Presets to re-rank ecosystems for your specific engineering scenario.

Final 100-Point Benchmark Scorecard (50 Audited Criteria × 2 / 1 / 0)

Audited Section (Click to Expand) Max Devart OSS CData Airbyte DataDirect Fivetran + dbt Cloud DWH Simba
▸ Sec 01 · Architecture, Runtimes & MCP/SK 6 criteria · click to inspect 12 10 8 7 4 5 5 3 7
▸ Sec 02 · Pricing Transparency & Paywalls 5 criteria · click to inspect 10 8 10 5 6 2 4 4 1
▸ Sec 03 · RAG Ingestion TCO & Egress 6 criteria · click to inspect 12 12 10 6 6 7 2 3 5
▸ Sec 04 · Rebundling, Legacy & Exit Cost 7 criteria · click to inspect 14 13 11 9 12 11 5 3 12
▸ Sec 05 · Hybrid Vector+SQL & Drivers 7 criteria · click to inspect 14 13 11 3 3 5 2 8 5
▸ Sec 06 · Containers & CI/CD Activation 5 criteria · click to inspect 10 9 10 3 6 6 6 6 3
▸ Sec 07 · Text-to-SQL Security & Guardrails 7 criteria · click to inspect 14 13 6 9 6 8 11 11 8
▸ Sec 08 · Multi-Agent Concurrency & Compliance 7 criteria · click to inspect 14 11 9 11 9 7 10 10 8
Total Weighted Score (/ 100) 100 89 75 53 52 51 45 48 49

Workload Architecture Advisor

Low-Volume Prototype (≤500K MAR)

OSS Npgsql / Fivetran Free / Single MCP

Start at $0 with Npgsql + CommunityToolkit.VectorData.PgVector (for PostgreSQL SK), Devart Free Single-Source MCP during 30-day evaluation, or Fivetran Free (≤500K MAR). Upgrade before hitting metered MAR or 10+ concurrent agents.

Hybrid RAG (10M–50M MAR)

PG halfvec+DiskANN + Zero-MAR ODBC/SSIS

Keep SQL and vectors in PostgreSQL or Oracle 26ai to save $20.9K–$28.6K over 3 years ($0 CDC Sync Tax), and ingest via flat-rate Devart ODBC ($1,989/yr cash) or SSIS to save up to 91.8% vs. Fivetran V.11.

High-Concur / Regulated On-Prem

Streamable HTTP + PgBouncer/DRCP + RBAC

Terminate parallel agents at a Stateless Streamable HTTP gateway backed by PgBouncer 1.21+ or Oracle DRCP, enforce DB-kernel READ ONLY roles + strict SQL AST, and connect behind firewalls via In-Driver SSH or SecureBridge TLS 1.3.

.NET 11 / EF Core 11 / SSIS Shop

Devart dotConnect 2026.1 + Entity Developer

Deploy 95 MB Alpine (musl) microservices with Direct=True and License Key=...; in the connection string. Slice 500-table ERPs into <15-table bounded DbContexts with DbCommandInterceptor and OpenTelemetry.

Live Federated SaaS Tool-Calling

CData Connect AI / Local SQL Cache

Use CData Connect AI Derived Views (-97.6% tokens) when cross-system live SaaS federation outweighs Business SSO Quote-Only gating—or replicate CRM/ERP data locally via Zero-MAR ODBC/SSIS to eliminate HubSpot/NetSuite rate-limit bursts.

Objective Verdict Cards (8 Ecosystems)

Devart Connectivity

89 / 100

Leads: Zero-MAR RAG TCO (0.28M MAR break-even), Day-1 .NET 11 / EF11 (95 MB Alpine), legacy reach (Oracle/Firebird/SAP/DB2), Delphi PgDAC, In-Driver SSH, public entry pricing.
Gaps & Caveats: No official Semantic Kernel VectorData store; Subscription ODBC needs Site/OEM for offline Docker; MCP relies on licensed ODBC after 30 days.

Open-Source Stack

75 / 100

Leads: $0 MIT/Apache license, sole official Semantic Kernel VectorData (Npgsql), Arrow ADBC (206k rows/s), zero CI/CD key friction.
Gaps & Caveats: 13 reference OSS MCPs archived (0.6.2 SQL bypass); weak legacy enterprise reach (SAP/Firebird/DB2); in-house CVE patching & pooling ops.

CData Software

53 / 100

Leads: 350+ SaaS/DB sources, hosted Connect AI MCP, Derived Views (-97.6% input tokens) & Postgres query cache.
Gaps & Caveats: Entra/Okta SSO gated to Quote-Only Business tier; node-locked Docker requires sales-gated RTK; no .NET 11 / EF Core 11.

Airbyte (Cloud & Core)

52 / 100

Leads: Portable K8s/Terraform & PyAirbyte RAG loaders, lower storage lock-in than cloud DWHs, transparent base tiers.
Gaps & Caveats: Sept 2026 doubled overage credits to $5.00/cr; batch ELT rather than live direct driver or Text-to-SQL AST guardrail.

Progress DataDirect

51 / 100

Leads: High-performance wire-protocol ODBC/JDBC, Linux ARM64, on-prem HDP 5.0 behind firewalls, Kerberos/TLS.
Gaps & Caveats: 100% Quote-Only opaque pricing; 0 native MCP servers; no .NET 11 / EF Core 11; gated HDP tarball.

Fivetran + dbt Labs

45 / 100

Leads: 700+ managed ELT connectors, dbt MCP GA, and Semantic Layer achieving 99.1% Text-to-SQL accuracy.
Gaps & Caveats: V.11 bills deletes & History MAR ($71.5K–$153.1K/yr @ 50M); 5-meter cost stacking; up to $277.3K exit cost.

Snowflake / Databricks / Fabric

48 / 100

Leads: Turnkey governed AI (Cortex Analyst, Databricks Genie, OneLake RBAC) inside a single cloud boundary.
Gaps & Caveats: 36-mo Oracle XStream lock (Snowflake), free Genie ending Jan 31, 2027, Fabric 57/86 preview + 25×25 cap, AI credit token bloat.

Simba / insightsoftware

49 / 100

Leads: Governed single-endpoint Simba Agentic Intelligence MCP and battle-tested ODBC 3.8 / JDBC 4.2 engines.
Gaps & Caveats: Steep entry floor ($2,625/yr single desktop, $15K+/yr dept, Agentic AI Quote-Only), gated .lic CI/CD friction, no .NET 11.

Production FAQ (2026 Audit Reference)

Which AI database connector should I choose by runtime in 2026?

Choose Npgsql + CommunityToolkit.VectorData.PgVector when you need an official Microsoft Semantic Kernel VectorData store on PostgreSQL. Choose Devart dotConnect 2026.1 for multi-engine .NET 11 and EF Core 11 apps (Oracle 23ai/26ai, BigQuery, MongoDB) via custom [KernelFunction] plugins. Choose Devart ODBC Drivers or Free Single-Source MCP Servers ($0 server + ODBC) for Python LangChain, Claude Desktop, and Cursor.

Which providers ship Day-1 support for .NET 11 and Entity Framework Core 11?

Npgsql and Devart dotConnect 2026.1 (plus Entity Developer) provide Day-1 .NET 11 and EF Core 11 support—including JsonPathExists, JsonContains, FullJoin, primitive collections, and new dotConnect for Google BigQuery and MongoDB providers. Microsoft.Data.SqlClient 7.0 has an EF11 RRF vector query bug requiring 2 queries in C#, while CData and Progress DataDirect ADO.NET lack EF11 support.

Why are prompt rules, pyodbc readonly=True, and MCP ToolAnnotations insufficient after CVE-2026-17351?

System prompts, pyodbc readonly=True (SQL_ATTR_ACCESS_MODE), and MCP readOnlyHint/destructiveHint annotations are advisory UI or driver hints that do not stop crafted SQL or RCE chains like CVE-2026-17351 (CVSS 9.4, sqlparse bypass to COPY ... TO PROGRAM). Production deployments require database-kernel RBAC (PostgreSQL NOINHERIT/Standby, Oracle READ ONLY, Firebird isc_tpb_read), strict SQL AST parsing, and bounded schemas.

When should I use Hybrid SQL+Vector (pgvector / Oracle 26ai) instead of Pinecone or Qdrant?

Use unified Hybrid SQL+Vector (PostgreSQL halfvec + DiskANN, Oracle 26ai, or MongoDB 8.2+) when transactional ACL consistency and TCO matter: it eliminates the $850–$2,000/mo CDC Sync Tax and saves $20,900–$28,620 over 3 years. Choose Qdrant (8–12 ms p99), Weaviate (16 ms), or Pinecone (18 ms) when you require sub-20 ms p99 latency at 10M–100M+ vectors without manual partitioning.

How much does multi-cloud exit cost under data stack rebundling vs. open protocols?

Migrating a 10-source stack off a rebundled cloud warehouse (Fivetran + dbt + proprietary DWH locks) averages 1,680 engineering hours and $277,300 over 12 months (including $25,000 in stranded proprietary artifacts). Decoupled architectures built on open Apache Iceberg tables, MCP, and direct Zero-MAR drivers reduce exit effort to 480 hours and $71,325 (-74.3%).

At what Monthly Active Rows (MAR) volume do flat-rate Zero-MAR drivers break even?

For a 5-source RAG ingestion pipeline, Devart ODBC ($1,989/yr cash license; $5,856/yr loaded with AWS worker compute) breaks even at 0.13M–0.32M MAR cash (0.44M–0.98M MAR loaded) against metered Fivetran V.11 plans, and at 4.88M–14.09M MAR against Airbyte Cloud Standard (7 credits/M)—saving up to 91.8% at 50M MAR.

Why do 10–50 parallel stdio MCP agents crash connection pools, and how much does DTO/CSV cut token bloat?

Spawning 10–50 independent stdio MCP processes opens 1,000–5,000 unpooled sockets, exhausting PostgreSQL max_connections (100), NetSuite slots (20), and HubSpot burst limits (190 req/10s). Moving to a Stateless Streamable HTTP gateway (MCP 2026-07-28 RC) with PgBouncer 1.21+ or Oracle DRCP fixes socket exhaustion, while replacing raw SELECT * JSON (4.0% density) with flat DTOs or RFC 4180 CSV cuts payload bytes by 92.1% to 95.6%.

What are the smallest Docker container footprints without Oracle Instant Client?

Managed .NET 8–11 providers running Direct=true on aspnet:alpine (musl) achieve ~42 MB compressed / 95 MB uncompressed footprints, and Python 3.12-slim + Devart ODBC (glibc) builds run around ~60 MB compressed / 155 MB uncompressed—avoiding the 382.3 MB compressed / 745–850 MB uncompressed footprint and DPI-1047 errors of legacy Oracle Instant Client / cx_Oracle stacks.

SECTION 10 · EVALUATED PRODUCT DIRECTORY & VERIFIED E-E-A-T SOURCES

Evaluated Product Directory & Verified Primary Sources

Direct vendor specification links (routed via /goto/<slug> with rel="sponsored nofollow noopener") alongside the primary public standards, CVE advisories, and peer-reviewed benchmarks referenced throughout this audit.

Evaluated Connectivity Stacks (Direct Specification Links)

ODBC Driver

Devart ODBC Drivers (92+ Sources)

$169.95/yr single | $499.95/yr Universal promo · 30-day free trial

Official Specs & Docs →
Managed .NET Provider

Devart dotConnect (ADO.NET / .NET 11 & EF Core 11)

$269.95/yr (DB2 Dev) | Universal/Server Quote-Only · 30-day trial / 30-day money-back

Official Specs & Docs →
MCP Server

Devart MCP Servers (20 Servers incl. Universal v1.1.0)

$0 single-source (+ ODBC) | $99.95/yr or $199.95 Universal · 30-day free trial (Universal)

Official Specs & Docs →
Zero-MAR ETL Pipeline

Devart SSIS Data Flow Components (50+ Sources)

$209.95/yr MySQL Dev | $499.95/yr Bundle | Server Quote-Only · 30-day free trial

Official Specs & Docs →
Schema Governance & Modeling

Devart Entity Developer (ORM & DTO Designer)

$0 Express (10 entities) | $269.95 Std | $319.95–$389.95 Pro · 30-day trial / money-back

Official Specs & Docs →
Zero-Trust Transport & Native DAC

Devart SecureBridge & Delphi DACs (PgDAC / UniDAC / ODAC)

SecureBridge $119.95–$359.95 | UniDAC $419.95–$1,079.95 · 60-day money-back guarantee

Official Specs & Docs →
Federated MCP & Drivers

CData Software (Connect AI & v26.0.x Drivers)

Connect AI $79–$159/mo (annual) | Dev Driver $499/yr | RTK Quote-Only · 14-day (Connect AI) / 30-day (Drivers)

Official Specs & Docs →
Managed Cloud ELT

Fivetran (Context Layer, Agent MCP & ELT)

$0 Free (<=500K MAR) | Paid $12,000/yr annual floor · 14-day account + 14-day per connector

Official Specs & Docs →
ELT Platform

Airbyte (Cloud Credits & Self-Hosted Core)

$0 OSS Core | Cloud $20/mo Std + $5/cr | Plus from $189/mo · 14-day Cloud trial

Official Specs & Docs →
Enterprise Wire-Protocol

Progress DataDirect (HDP 5.0 & Autonomous REST)

100% Quote-Only / Not Publicly Disclosed · 15-day (Autonomous REST ODBC)

Official Specs & Docs →
Enterprise Drivers & Governed MCP

Simba / Magnitude (insightsoftware)

$2,625/yr Single Desktop | $15,000+/yr Dept | Agentic AI Quote-Only · Gated forms / Promo through Dec 31, 2026

Official Specs & Docs →
OSS Managed & Reference MCP

Open-Source Stack (Npgsql + CommunityToolkit + Active MCP)

$0 (MIT / Apache 2.0) · Always Free

Official Specs & Docs →

Verified Primary Sources & E-E-A-T References

Primary Source / Standard Domain Audit Scope & Referenced Findings
NIST NVD (CVE-2026-17351 & CVE-2026-12045) nvd.nist.gov CVSS 9.4 Critical SQL parser bypass chain (sqlparse → COPY ... TO PROGRAM RCE).
OWASP Top 10 for LLM Applications 2026 genai.owasp.org 2025 → 2026 rank shifts (LLM06 +4, LLM03 +3, LLM08 Hidden Context Exposure).
EUR-Lex · Regulation (EU) 2026/1744 eur-lex.europa.eu Digital Omnibus AI Act timelines: Art. 50 active Aug 2, 2026; Annex III Art. 12/14 deferred to Dec 2, 2027.
Model Context Protocol (MCP 2026-07-28 RC) modelcontextprotocol.io Stateless Streamable HTTP, OAuth 2.1 + RFC 8707, SEP-414 W3C Trace Context, and UI-only ToolAnnotations.
Microsoft .NET 11 & EF Core 11 Docs learn.microsoft.com Nov 2026 release: Runtime Async (254 ns → 117 ns), JSON partial updates, primitive collections, FULL JOIN.
Microsoft Semantic Kernel VectorData learn.microsoft.com Migration to CommunityToolkit.VectorData.PgVector and deprecation of legacy SK.Connectors.PgVector.
arXiv:2605.29670 (EviLink / Spider2-Snow) arxiv.org Bounded schema linking: prompt token reduction from 1,991.1K → 116.5K at 93.04% strict recall.
IETF RFC 8707 (OAuth 2.0 Resource Indicators) datatracker.ietf.org Token audience binding required by MCP 2026-07-28 RC Streamable HTTP auth.
W3C Trace Context Specification w3.org Distributed tracing standard referenced by MCP SEP-414 & OpenTelemetry.
MCP Reference Servers Repository github.com Archive status of 13 legacy reference MCP servers & 0.6.2 SQL bypass history.
Npgsql (.NET PostgreSQL Data Provider) github.com Open-source managed .NET 11 provider powering official SK VectorData.
sqlglot (Python & Rust SQL AST Parser) github.com Strict vs. Lenient Command fallback behavior & 0.44 ms sqlglot[rs] parsing.
JSQLParser 5.3 (Java SQL AST Parser) github.com Single-grammar SQL AST coverage benchmarked against PostgreSQL, Snowflake & T-SQL.
Apache Arrow ADBC github.com High-throughput columnar Python database connectivity (206k rows/s).
PostgreSQL Role & NOINHERIT Docs postgresql.org Kernel-level least-privilege read-only role enforcement & pg_read_all_data caveats.
pyodbc (Python ODBC Bridge) github.com SQL_ATTR_ACCESS_MODE (readonly=True) advisory hint mechanics in Python.
PostgreSQL pgvector & pgvectorscale github.com float32 2,000d vs. halfvec 4,000d HNSW limits, binary quantization (32× RAM reduction), DiskANN.
PgBouncer 1.21+ Transaction Pooling pgbouncer.org Prepared statement & SET LOCAL multiplexing for high-concurrency multi-agent SQL gateways.
AWS Lambda INIT & US-East Network Pricing aws.amazon.com Billable INIT phase (Aug 2025) and NAT Gateway / Cross-AZ / PrivateLink egress cost multipliers.
Apache Iceberg Open Table Format iceberg.apache.org Open multi-engine table storage enabling decoupled -74.3% multi-cloud exit architectures.