Which databases are supported by this skill?

The skill supports DuckDB (Parquet), PostgreSQL (Npgsql), MySQL (MySql.Data), MS SQL Server (Sage 1000/X3), and DBISAM (Exportmaster) via ODBC and native drivers.

How does it handle different SQL parameter styles?

It provides specific implementation details for ODBC '?' placeholders, native MySQL '@parameter' styles, and PostgreSQL '$1, $2' positional parameters.

Does this skill provide support for ORM frameworks?

This skill focuses on high-performance ADO.NET and ODBC patterns, providing specific wrappers and mapping techniques that offer more control than standard ORMs.

What is the ExecuteAndMap pattern?

It is a specialized wrapper pattern included in this skill that uses lambda mappers to provide type-safe object hydration while automatically managing connection lifecycles.

C# Database Integration Patterns

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

bylawless-m

Database Management

Provides standardized RDBMS access patterns and best practices for C# applications across multiple database engines including PostgreSQL, MySQL, and DuckDB.

About

This skill equips Claude with specialized knowledge for implementing robust database access layers in C#. It offers a comprehensive library of proven patterns for working with diverse systems such as DuckDB (for Parquet files), PostgreSQL (via Npgsql), MySQL, and legacy ODBC connections like SQL Server or DBISAM. By enforcing the ExecuteAndMap pattern, type-safe mapping, and proper connection lifecycle management, this skill ensures that database code is performant, secure against injection, and consistent across different RDBMS environments.

Key Features

Robust connection management and null-safety enforcement with IsDBNull checks
Standardized access patterns for DuckDB, PostgreSQL, MySQL, SQL Server, and DBISAM
Comprehensive parameter styling guidance for ODBC (?), MySQL (@), and PostgreSQL ($n)
0 GitHub stars
Optimized handling for specialized data types like PostgreSQL arrays and Parquet files
Type-safe result mapping using the ExecuteAndMap lambda pattern

Use Cases

Implementing high-performance Parquet file queries using DuckDB in a .NET environment
Standardizing database access layers across microservices using different SQL dialects
Refactoring legacy ODBC database code to modern native C# drivers

About

Key Features

Robust connection management and null-safety enforcement with IsDBNull checks
Standardized access patterns for DuckDB, PostgreSQL, MySQL, SQL Server, and DBISAM
Comprehensive parameter styling guidance for ODBC (?), MySQL (@), and PostgreSQL ($n)
0 GitHub stars
Optimized handling for specialized data types like PostgreSQL arrays and Parquet files
Type-safe result mapping using the ExecuteAndMap lambda pattern

Use Cases

Implementing high-performance Parquet file queries using DuckDB in a .NET environment
Standardizing database access layers across microservices using different SQL dialects
Refactoring legacy ODBC database code to modern native C# drivers