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

0•

Database Management

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

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.

Key Features

01Advanced DuckDB support for querying Parquet files directly

02ExecuteAndMap pattern for type-safe, null-safe result mapping

03Standardized parameter styling for ODBC, native MySQL, and Npgsql

04PostgreSQL-specific optimizations for arrays and function type-casting

050 GitHub stars

06Optimized library selection for DuckDB, PostgreSQL, MySQL, and SQL Server

Use Cases

01Implementing high-performance PostgreSQL access with native Npgsql array support

02Maintaining legacy database connections for Sage1000, X3, and Exportmaster systems

03Integrating DuckDB to query local Parquet data files with ODBC

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lawless-m/petty Databases

For use in Claude.ai and ChatGPT

Download Skill