sqlspec-asyncpg

Manage SQLSpec asyncpg adapter configuration and parameter profiles.

15|4|Updated Jan 20, 2026

Search Tags:#database #python #sql #adapter #asyncpg #sqlspec

Ready to run

npx skills add https://github.com/cofin/flow --skill sqlspec-asyncpg

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sqlspec-asyncpg
Source: https://github.com/cofin/flow/tree/main/skills/sqlspec-asyncpg
Command: npx skills add https://github.com/cofin/flow --skill sqlspec-asyncpg

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the complexities of working with the asyncpg adapter for SQLSpec, streamlining the implementation, debugging, and review of its configuration and driver behavior.

Core Features & Use Cases

Adapter Configuration: Manages asyncpg-specific connection configurations and driver features within SQLSpec.
Parameter Handling: Supports asyncpg's positional placeholder style ($1, $2, ...) and translates them automatically.
Driver Integration: Facilitates the use of asyncpg's native pipeline execution for statement stacks.
Use Case: Debugging an issue where asyncpg adapter is not correctly mapping parameter profiles for a complex SQL query.

Quick Start

Use the sqlspec-asyncpg skill to review the parameter profile for asyncpg adapter.

Frequently Asked Questions about sqlspec-asyncpg

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

FAQPage Schema

How do I configure the asyncpg adapter in SQLSpec for PostgreSQL connections?▼

You configure the asyncpg adapter in SQLSpec by managing connection configurations and driver features through the skill, which integrates directly with SQLSpec's configuration pipeline to establish PostgreSQL database connections.

Why does asyncpg fail to correctly map parameter profiles for complex SQL queries?▼

asyncpg parameter mapping failures often stem from positional placeholder mismatches; this skill helps debug and review parameter profiles, ensuring asyncpg's `$1`, `$2` style translates automatically within SQLSpec's execution pipeline.

Does SQLSpec support asyncpg's positional placeholder style for SQL statements?▼

Yes, SQLSpec supports asyncpg's positional placeholder style by automatically translating `$1`, `$2` parameters, allowing you to execute SQL queries through the asyncpg driver without manually adjusting placeholder syntax.

How do I debug driver behavior and pipeline execution issues with the asyncpg adapter?▼

You debug asyncpg adapter driver behavior by reviewing adapter configuration and testing statement execution, utilizing the skill to inspect native pipeline execution for statement stacks within SQLSpec's execution pipeline.

What is the best way to test asyncpg adapter configuration and parameter handling in SQLSpec?▼

The best way to test asyncpg adapter configuration is by running adapter-specific tests provided through the skill, verifying parameter profiles and driver behavior within SQLSpec's statement execution pipelines.

Can I use asyncpg's native pipeline execution for statement stacks in SQLSpec?▼

Yes, you can use asyncpg's native pipeline execution for statement stacks in SQLSpec, as the adapter facilitates driver integration to process multiple statements efficiently through the execution pipeline.