Can I use this skill to query Parquet files?

Yes, it includes specific patterns for using the DuckDB ODBC driver to query Parquet files directly using the read_parquet() function with optimized timeout settings.

How does this skill handle different SQL parameter styles?

The skill provides specific guidance for each driver: '?' placeholders for ODBC, '@parameter' for MySQL, and '$1, $2' positional parameters for native PostgreSQL.

Does it support legacy ERP databases?

Yes, it includes proven access patterns for Sage1000, Sage X3, and Exportmaster (DBISAM) via ODBC connections.

Which database drivers does this skill support?

It supports native drivers like Npgsql for PostgreSQL and MySql.Data for MySQL, as well as System.Data.Odbc for DuckDB, SQL Server, and legacy systems like DBISAM.

What is the ExecuteAndMap pattern?

It is a specialized mapping pattern that uses a ServiceLib ODBC wrapper with lambda expressions to provide type-safe mapping of database rows to C# objects while handling null safety.

C# Database Access Patterns

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

bylawless-m

•

Database Management

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

This skill provides specialized guidance for C# developers working with a diverse range of database systems, from modern PostgreSQL and DuckDB instances to legacy SQL Server and DBISAM environments. It offers standardized patterns for library selection (Npgsql, MySql.Data, ODBC), type-safe mapping via the ExecuteAndMap pattern, and robust connection management. By following these production-proven implementation details, developers can ensure proper parameterization, efficient timeout handling, and optimized performance for complex operations like querying Parquet files or handling PostgreSQL arrays.

Key Features

015 GitHub stars

02DuckDB ODBC patterns for direct Parquet file querying

03Native driver optimization for PostgreSQL (Npgsql) and MySQL

04Type-safe result mapping using the ExecuteAndMap lambda pattern

05Standardized parameter handling to prevent SQL injection across different drivers

06Legacy system support for Sage1000, X3, and Exportmaster (DBISAM)

Use Cases

01Migrating legacy ODBC database connections to high-performance native drivers

02Implementing type-safe data access layers in C# ServiceLib projects

03Performing ad-hoc PostgreSQL queries using specialized CLI tool configurations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lawless-m/claude-skills Databases

For use in Claude.ai and ChatGPT

Download Skill