Access DuckDB, MySQL, PostgreSQL, SQL Server, and DBISAM in C# with typed queries.
npx skills add https://github.com/lawless-m/claude-skills --skill databases
Please help me install this Agent Skill. Skill: Databases Source: https://github.com/lawless-m/claude-skills/tree/main/Databases Command: npx skills add https://github.com/lawless-m/claude-skills --skill databases
This Skill simplifies complex relational database management system (RDBMS) interactions in C#, providing proven patterns for various databases and drivers. It eliminates the guesswork and boilerplate code for connecting, querying, and mapping data, ensuring consistent and efficient database operations.
ExecuteAndMap pattern for reliable C# object mapping from query results.Use the Databases skill to help me connect to a PostgreSQL database and execute a query with array parameters.
High-intent search queries and answers about installing and using this skill.
Use parameterized queries with native or ODBC drivers to connect reliably across PostgreSQL, MySQL, SQL Server, DuckDB, and DBISAM. The ExecuteAndMap pattern enforces using statements, handles timeouts, and ensures type-safe result mapping while preventing SQL injection and resource leaks.
Yes. PostgreSQL array parameters are seamlessly managed through native driver support, allowing you to pass and retrieve array data structures directly in parameterized queries without manual serialization.
The ExecuteAndMap pattern provides type-safe, reliable mapping from result sets to C# objects. It handles null-safety, enforces resource management, and works consistently across all supported databases—PostgreSQL, MySQL, SQL Server, DuckDB, and DBISAM.
Yes. The Skill supports cross-DBMS connectivity, making it suitable for scenarios that require extracting data from legacy SQL Server and loading into PostgreSQL or other modern databases while handling different connection types and data structures.
Yes. Both native and ODBC parameter styles are supported, giving you flexibility to use ODBC drivers for databases like DBISAM or to standardize on ODBC across your C# application regardless of the underlying database.
The ExecuteAndMap pattern includes built-in timeout handling and null-safety mechanisms that enforce defensive coding practices through using statements and parameterized queries, protecting against connection leaks and unexpected null references.
kourou25Connect Node.js applications to XuguDB databases via ODBC bridge or Sequelize ORM.
Datus-aiGenerate JSON, CSV, or markdown reports from SQL query results.
MicrockPlan and execute database migrations with rollback and integrity validation.
diegoknskStandardize database persistence in .NET 8/10 applications using Dapper.