Skills
.Work. You
Rest

sqlspec

Community

Type-safe SQL query mapper for Python.

Software Engineering#type safety#database#python#sql#orm#adapter#sqlglot
Authorcofin
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill provides a robust and type-safe way to interact with various SQL databases from Python, abstracting away many of the complexities of direct database interaction and ensuring data integrity.

Core Features & Use Cases

  • Type-Safe SQL: Ensures parameters and results are handled with type information throughout the pipeline.
  • Multi-Adapter Support: Connects to a wide range of databases including PostgreSQL, MySQL, SQLite, BigQuery, and more.
  • Framework Integration: Seamlessly integrates with web frameworks like Litestar, FastAPI, and Starlette.
  • Use Case: Develop a Python application that needs to read and write data to a PostgreSQL database, ensuring that all SQL queries are validated and parameters are correctly typed before execution, and then deploy it using Litestar with automatic transaction management.

Quick Start

Use the sqlspec skill to connect to a PostgreSQL database using the provided DSN and execute a SELECT query.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: sqlspec
Download link: https://github.com/cofin/flow/archive/main.zip#sqlspec

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.