What is the recommended way to map database results to C# objects?

The skill promotes the 'ExecuteAndMap' pattern using lambda mappers and explicit IsDBNull checks to ensure type safety and prevent runtime exceptions.

How does this skill handle PostgreSQL-specific features?

It provides specific instructions for Npgsql, including positional parameters ($1, $2) and native array support, as well as mandatory type casting for VARCHAR function parameters.

Which database engines does this Claude Code skill support?

It supports a wide range of engines including DuckDB, PostgreSQL, MySQL, SQL Server (Sage1000/X3), and DBISAM (Exportmaster).

Can I use this for querying files without a traditional server?

Yes, it includes patterns for using DuckDB's ODBC driver to execute SQL queries directly against Parquet files using the read_parquet() function.

C# Database Access Patterns

Name: C# Database Access Patterns
Author: lawless-m

bylawless-m

Gestión de Bases de Datos

Standardizes RDBMS integration in C# for DuckDB, PostgreSQL, MySQL, and legacy systems using optimized drivers and patterns.

Acerca de

This skill equips Claude with standardized implementation patterns for managing various database systems within C# environments. It provides specialized guidance on library selection—recommending Npgsql for PostgreSQL and native drivers for MySQL while utilizing ODBC for DuckDB and legacy systems like Sage1000 and DBISAM. By enforcing the ExecuteAndMap pattern, it ensures type-safe result mapping and consistent connection management. It is particularly useful for developers handling diverse data sources, from Parquet files in DuckDB to complex PostgreSQL array types and enterprise ERP databases.

Características Principales

Advanced DuckDB support for querying Parquet files directly
ExecuteAndMap pattern for type-safe, null-safe result mapping
Standardized parameter styling for ODBC, native MySQL, and Npgsql
PostgreSQL-specific optimizations for arrays and function type-casting
0 GitHub stars
Optimized library selection for DuckDB, PostgreSQL, MySQL, and SQL Server

Casos de Uso

Implementing high-performance PostgreSQL access with native Npgsql array support
Maintaining legacy database connections for Sage1000, X3, and Exportmaster systems
Integrating DuckDB to query local Parquet data files with ODBC

Acerca de

Características Principales

Advanced DuckDB support for querying Parquet files directly
ExecuteAndMap pattern for type-safe, null-safe result mapping
Standardized parameter styling for ODBC, native MySQL, and Npgsql
PostgreSQL-specific optimizations for arrays and function type-casting
0 GitHub stars
Optimized library selection for DuckDB, PostgreSQL, MySQL, and SQL Server

Casos de Uso

Implementing high-performance PostgreSQL access with native Npgsql array support
Maintaining legacy database connections for Sage1000, X3, and Exportmaster systems
Integrating DuckDB to query local Parquet data files with ODBC