Provides standardized RDBMS access patterns and type-safe mapping for DuckDB, PostgreSQL, MySQL, SQL Server, and DBISAM in C#.
This skill equips Claude with production-grade implementation patterns for interacting with various database systems using C#. It focuses on best practices for library selection, connection management, and parameter styling across diverse environments including modern DuckDB Parquet queries and legacy systems like Sage 1000 and DBISAM. By leveraging standardized wrappers and the ExecuteAndMap pattern, it ensures that database code is performant, null-safe, and easy to maintain while providing specialized guidance for PostgreSQL-specific features like native arrays and explicit type casting.
主要功能
01Type-safe result mapping using the ExecuteAndMap lambda pattern
02Configured parameter styles for ODBC (?), MySQL (@), and PostgreSQL ($n)
03Multi-RDBMS support including DuckDB, PostgreSQL, MySQL, SQL Server, and DBISAM
04Integration with PgQuery tool for ad-hoc PostgreSQL query execution
050 GitHub stars
06Built-in handling for DuckDB Parquet file querying and timeout optimization
使用场景
01Querying large Parquet datasets directly using DuckDB ODBC connections
02Executing complex PostgreSQL functions requiring explicit VARCHAR type casting and native array support
03Implementing null-safe data extraction from legacy ERP systems like Sage 1000 and X3
