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

0•

データベース管理

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.

主な機能

01Native PostgreSQL array handling and explicit type casting for function calls.

02Implementation of the ExecuteAndMap pattern for type-safe result mapping.

030 GitHub stars

04Comprehensive support for DuckDB, PostgreSQL, MySQL, SQL Server, and DBISAM.

05Standardized parameter styling for ODBC (?), MySQL (@), and PostgreSQL ($1) syntax.

06Optimized configurations for high-performance DuckDB Parquet file querying.

ユースケース

01Developing high-performance data pipelines that query Parquet files directly using DuckDB.

02Implementing reliable data access layers for enterprise ERP systems like Sage1000 and X3.

03Standardizing database connection and mapping logic across multi-engine C# applications.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lawless-m/toberboon Databases

For use in Claude.ai and ChatGPT

Download Skill