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

0•

データベース管理

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

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.

主な機能

01Robust connection management and null-safety enforcement with IsDBNull checks

02Standardized access patterns for DuckDB, PostgreSQL, MySQL, SQL Server, and DBISAM

03Comprehensive parameter styling guidance for ODBC (?), MySQL (@), and PostgreSQL ($n)

040 GitHub stars

05Optimized handling for specialized data types like PostgreSQL arrays and Parquet files

06Type-safe result mapping using the ExecuteAndMap lambda pattern

ユースケース

01Implementing high-performance Parquet file queries using DuckDB in a .NET environment

02Standardizing database access layers across microservices using different SQL dialects

03Refactoring legacy ODBC database code to modern native C# drivers

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lawless-m/stinkyspy Databases

For use in Claude.ai and ChatGPT

Download Skill