add-sql-dialect

Generate subclass templates and registration logic for new SQL dialects in pycel2sql.

Updated Feb 26, 2026
One-click install
npx skills add https://github.com/SPANDigital/pycel2sql --skill add-sql-dialect
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: add-sql-dialect
Source: https://github.com/SPANDigital/pycel2sql/tree/main/.claude/skills/add-sql-dialect
Command: npx skills add https://github.com/SPANDigital/pycel2sql --skill add-sql-dialect

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pycel2sql, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill facilitates the extension of the pycel2sql tool to support additional SQL dialects, making it adaptable to various database systems.

Core Features & Use Cases

  • Supports new SQL dialects: Automatically creates necessary components to integrate a new SQL dialect.
  • Dialect comparison tables: Provides guidance on selecting the most appropriate dialect based on existing ones.
  • Code templates and documentation: Offers scripts and guidelines to ease the process of adding new dialects.
  • Use Case: For instance, if your project relies on a proprietary database, you can use this Skill to extend pycel2sql support for that specific dialect.

Quick Start

Execute the command 'python .claude/skills/add-sql-dialect/scripts/scaffold_dialect.py <template> <new-name> <NewClassPrefix>' to start adding a new dialect.

Frequently Asked Questions about add-sql-dialect

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I add support for a new SQL dialect in pycel2sql?

To add a new SQL dialect to pycel2sql, run the scaffold script with your desired template, new dialect name, and class prefix. This automatically generates the necessary subclass templates and registration logic to integrate the new database engine.

What is SQL dialect extension and when do I need it for a Python library?

SQL dialect extension adapts a Python library to support additional database systems by generating specific subclasses and registration logic. You need it when your project relies on a proprietary database or an unsupported backend like a specialized PostgreSQL variant.

Does pycel2sql support integrating new database engines with continuous integration workflows?

Yes, extending SQL dialect support in pycel2sql integrates with continuous integration workflows. The Skill creates the necessary code templates and registration components to ensure new database engines function within your automated CI pipelines.

What's the best way to compare existing SQL dialects before adding a new one?

The best way to compare existing SQL dialects is by using the provided dialect comparison tables. These tables offer guidance on selecting the most appropriate base dialect to scaffold your new database engine support from.

Can I use this approach to add SQL dialect support for proprietary database systems?

Yes, you can use this approach to add SQL dialect support for proprietary database systems. The Skill generates subclass templates and registration logic, allowing pycel2sql to adapt to your specific proprietary backend.

Do I need to manually write registration logic when extending pycel2sql with new SQL dialects?

No, you do not need to manually write registration logic when extending pycel2sql with new SQL dialects. The Skill automatically creates the necessary components and registration logic for the new database engine.