How does this skill handle different SQL parameter styles?

The skill guides Claude to use '?' placeholders for ODBC, '@' for native MySQL, and positional '$1, $2' parameters for native PostgreSQL access.

Which database drivers does this skill support?

It provides patterns for Npgsql (PostgreSQL), MySql.Data (MySQL), and System.Data.Odbc for various systems including DuckDB, SQL Server, and DBISAM.

Can this skill help with legacy system integration?

Yes, it includes specific patterns for legacy platforms like Sage1000, X3 MS SQL Server, and Exportmaster (DBISAM) using standardized ODBC wrappers.

What is the ExecuteAndMap pattern?

It is a specialized ServiceLib ODBC wrapper pattern that uses lambda mappers to provide type-safe result mapping while handling null checks and connection lifecycles automatically.

RDBMS Access Patterns

Name: RDBMS Access Patterns
Author: lawless-m

bylawless-m

数据库管理

Standardizes C# database integration across DuckDB, PostgreSQL, MySQL, and legacy ODBC systems using optimized implementation patterns.

关于

This skill provides Claude with specialized knowledge for implementing robust RDBMS access in C# environments. It covers a wide range of systems from modern PostgreSQL (Npgsql) and MySQL to specialized engines like DuckDB for Parquet files and legacy DBISAM (Exportmaster) systems. By utilizing the ExecuteAndMap pattern and enforcing strict connection management, it ensures type-safe data retrieval, proper parameter handling across different SQL dialects, and reliable performance in enterprise environments involving Sage1000, X3, and RocsMiddleware systems.

主要功能

Native PostgreSQL array handling and explicit type casting for function calls.
Implementation of the ExecuteAndMap pattern for type-safe result mapping.
0 GitHub stars
Comprehensive support for DuckDB, PostgreSQL, MySQL, SQL Server, and DBISAM.
Standardized parameter styling for ODBC (?), MySQL (@), and PostgreSQL ($1) syntax.
Optimized configurations for high-performance DuckDB Parquet file querying.

使用场景

Developing high-performance data pipelines that query Parquet files directly using DuckDB.
Implementing reliable data access layers for enterprise ERP systems like Sage1000 and X3.
Standardizing database connection and mapping logic across multi-engine C# applications.

关于

主要功能

Native PostgreSQL array handling and explicit type casting for function calls.
Implementation of the ExecuteAndMap pattern for type-safe result mapping.
0 GitHub stars
Comprehensive support for DuckDB, PostgreSQL, MySQL, SQL Server, and DBISAM.
Standardized parameter styling for ODBC (?), MySQL (@), and PostgreSQL ($1) syntax.
Optimized configurations for high-performance DuckDB Parquet file querying.

使用场景

Developing high-performance data pipelines that query Parquet files directly using DuckDB.
Implementing reliable data access layers for enterprise ERP systems like Sage1000 and X3.
Standardizing database connection and mapping logic across multi-engine C# applications.