DaffyDNAA SQL Server-compatible warehouse in VS Code. Query folders of Parquet, CSV, JSON and Excel files, and SQL Server, PostgreSQL, MySQL, SQLite and DuckDB databases, with T-SQL: from Microsoft's SQL Server extension (mssql), SSMS, Power BI, or your own code. One query can join last month's Parquet export to a table in SQL Server and another in PostgreSQL. DaffyDNA runs DaffyDB, which runs on DuckDB. DaffyDB is like Babelfish for PostgreSQL, which lets SQL Server clients work with PostgreSQL, but for DuckDB: it speaks SQL Server's wire protocol, translates T-SQL into DuckDB's SQL, and answers the catalog queries that SSMS, VS Code and Power BI ask. It is a single .NET tool, with no database server to install. DaffyDNA does nothing to a server itself: DaffyDB does the logging in and the reading, and mssql runs your queries. Everything listens only on your own machine. The warehouse
On a SQL Server source, DaffyDB SummaryOne page for the whole warehouse: the DaffyDB and DuckDB versions, every mount and schema, where its files and snapshots are, how to connect any client, and the last 50 queries clients sent, each with the DuckDB SQL it became. It also lists every folder's warehouse on this machine, to switch to in a click. Its Power BI section opens Power BI Desktop on the warehouse, with the one step that trips people up called out: choose Database, not Windows, when Power BI asks how to sign in. Connections: a vault for your loginsSQL Server, PostgreSQL and MySQL logins, and files and folders, saved once and mounted in any folder's warehouse whenever you need them. The SQL Server tab lists your mssql connections too, and shows which are mounted, with Mount, Unmount, Test, New password and Remove beside each. SQL logins and Entra applications (service principals) are supported. HealthChecks the .NET 10 SDK, DaffyDB, the mssql extension and DaffyDB's certificate, with an Install or Fix button where DaffyDNA can fix it. DaffyDNA installs and updates DaffyDB for you. Getting startedYou need:
Microsoft's SQL Server extension (mssql) is recommended: DaffyDNA uses it to run queries.
The guide opens by itself the first time DaffyDNA starts, and covers everything else: the ? on each section opens its page. Your passwordsPasswords you save are kept in VS Code's secret storage, encrypted by the operating system.
The warehouse listens on 127.0.0.1 only, and stops when VS Code closes. In a folder you haven't trusted, DaffyDNA starts nothing. LicenseDaffyDNA is MIT-licensed. Copyright (c) 2026 TroBeeOne LLC. DaffyDB is a separate package that DaffyDNA installs from NuGet. It is MIT-licensed too. DaffyDNA includes some open-source libraries: markdown-it, and tedious with the Azure libraries it
uses. Each keeps its own license, all of them permissive: MIT, ISC, BSD or Apache-2.0. They are
listed in Protocol and trademarksDaffyDNA implements nothing of SQL Server. It drives DaffyDB, which implements the Tabular Data Stream protocol from Microsoft's published MS-TDS specification. DaffyDNA is not affiliated with, endorsed by, or sponsored by Microsoft Corporation, and DaffyDB is not affiliated with Babelfish for PostgreSQL. Microsoft, SQL Server, Azure, Entra and Power BI are trademarks of Microsoft Corporation. ContactTroBeeOne LLC: trobee.one · LinkedIn |