Which driver is recommended for PostgreSQL access?

Npgsql is the recommended native driver for direct PostgreSQL access as it offers superior performance and native support for PostgreSQL-specific types like arrays.

Does this skill support legacy DBISAM databases?

Yes, it provides specific connection strings and query patterns for Exportmaster (DBISAM) using the System.Data.Odbc library.

How does this skill handle DuckDB queries?

It uses System.Data.Odbc with a specific DuckDB DSN, focusing on read_parquet() functions and optimized 60-second command timeouts for large file processing.

Why are explicit type casts required for PostgreSQL functions?

PostgreSQL treats VARCHAR without a length as a different type than VARCHAR(n). Explicit casts are necessary in SQL to ensure function signature matching for parameters.

What is the benefit of the ExecuteAndMap pattern?

ExecuteAndMap is a ServiceLib ODBC wrapper that uses lambda mappers to provide type-safe result mapping while automatically handling connection disposal.

C# Database Access Patterns

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

bylawless-m

0•

Database Management

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.

Key Features

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

Use Cases

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

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lawless-m/freebird Databases

For use in Claude.ai and ChatGPT

Download Skill