# Airia.DataStores.Common — One query surface over six database engines, shipped as a package.

> A .NET library that puts relational engines and a document store behind one interface: run a query, read the schema, pool the connections. Written so the cloud connector and the platform consume the same build instead of maintaining two drifting copies of the same provider matrix.

## Overview

A shared library that answers one question for every database an enterprise might point at an AI agent: how do you run a query and read a schema without the caller knowing which engine it is talking to.

## Stack

- .NET 9
- PostgreSQL
- SQL Server
- MySQL
- Snowflake
- Databricks
- MongoDB
- xUnit

## Highlights

- Six engines behind one interface, with the document store kept honestly separate.
- Schema description is part of the contract, not something bolted on later.
- Connection pooling behind the factory, so no caller manages a lifetime it did not open.
- Connection parameters as a dictionary — the library, not the caller, knows each engine’s spelling.
- Published as a versioned package, consumed by both the connector and the platform.

## Role

R&D Engineer — author, from the first commit · Jul 2025 – Oct 2025. Closed-source professional work — the write-up describes it without the source.

---

Source: https://felipealmeida.tech/projects/airia-datastores