GitHub
python-database-patterns
SQLAlchemy and database patterns for Python. Triggers on: sqlalchemy, database, orm, migration, alembic, async database, connection pool, repository pattern, unit of work.
☆ 124查看技能
“Python”的搜索结果
按技能名称、说明或 GitHub 作者匹配的结果。
分类目录: tools sql databases
全部技能
GitHub
sqlite-ops
Patterns for SQLite databases in Python projects - state management, caching, and async operations. Triggers on: sqlite, sqlite3, aiosqlite, local database, database schema, migration, wal mode.
☆ 124查看技能
GitHub
connection-pooling
Database and HTTP connection pooling patterns for Python async applications. Use when configuring asyncpg pools, aiohttp sessions, or optimizing connection lifecycle in high-concurrency services.
☆ 61查看技能
GitHub
dbt-materializations
Choosing and implementing dbt materializations (ephemeral, view, table, incremental, snapshots, Python models). Use this skill when deciding on materialization strategy, implementing incremental models, setting...
☆ 26查看技能
GitHub
grey-haven-database-conventions
Apply Grey Haven database conventions - snake_case fields, multi-tenant with tenant_id and RLS, proper indexing, migrations for Drizzle (TypeScript) and SQLModel (Python). Use when designing schemas, writing da...
☆ 19查看技能
GitHub
sqlalchemy-orm
SQLAlchemy Python SQL toolkit and ORM with powerful query builder, relationship mapping, and database migrations via Alembic
☆ 12查看技能
GitHub
pythonsqlalchemy
SQLAlchemy ORM patterns for Python database access. Use when defining models, writing queries, implementing upserts, working with JSON columns, or managing database sessions.
☆ 6查看技能
GitHub
debugging-orm-queries
Converts ORM calls to raw SQL and analyzes query performance. Detects N+1 queries, missing indexes, and other anti-patterns. Use when debugging slow queries, tracing ORM-generated SQL, or optimizing database pe...
☆ 4查看技能
GitHub
query-writer
Use this skill when writing or updating SQL queries (query.sql) or Python ETL scripts (query.py) following Mozilla BigQuery ETL conventions. ALWAYS checks for and updates existing tests when modifying queries....
☆ 3查看技能
GitHub
python-peewee
Patterns for using Peewee ORM with DatabaseProxy and scoped connections/transactions. Use when setting up DatabaseProxy, managing connection_context/atomic blocks, or writing tests with SQLite.
☆ 2查看技能
GitHub
sqlalchemy
SQLAlchemy Python SQL toolkit and ORM. Use for database models, queries, sessions, relationships, migrations, async database operations, and working with PostgreSQL, MySQL, SQLite, Oracle, SQL Server.
☆ 1查看技能
GitHub
duckdb
Fast in-process analytical database for SQL queries on DataFrames, CSV, Parquet, JSON files, and more. Use when user wants to perform SQL analytics on data files or Python DataFrames (pandas, Polars), run compl...
☆ 1查看技能
GitHub
databricks-sql
A skill for using Databricks SQL (SQL Warehouse) via SDK. Supports both Python (databricks-sql-connector) and Node.js (@databricks/sql). Use when: - Connecting to SQL Warehouse from Databricks Apps to execute...
☆ 1查看技能
GitHub
neo4j-patterns
Neo4j driver best practices for Python. Use when working with Neo4j connections, Cypher queries, transactions, or GraphRAG implementations.
☆ 0查看技能
GitHub
sqlmodel-orm-dbhelper
Design and implement production-grade database layers using SQLModel with SQLAlchemy 2.0 patterns. This skill should be used when users need to create database models, configure engines/sessions, design schemas...
☆ 0查看技能
GitHub
sqlmodel
Expert guidance for SQLModel - the Python library combining SQLAlchemy and Pydantic for database models. Use when (1) creating database models that work as both SQLAlchemy ORM and Pydantic schemas, (2) building...
☆ 0查看技能
GitHub
backend-migrations
Create and manage database migrations with reversible up/down methods, zero-downtime deployment strategies, and proper schema versioning. Use this skill when creating database migration files, altering table sc...
☆ 0查看技能
GitHub
postgresql-expert
Use when editing .sql files, reviewing SQL in Python/JavaScript/TypeScript code, writing database queries, or when user mentions PostgreSQL, SQL validation, query optimization, or database schema.
☆ 0查看技能
GitHub
sqlmodel-mastery
Comprehensive SQLModel skill for Python database operations with SQL databases. Use when working with SQLModel for (1) Designing database models and table schemas, (2) Creating relationships between tables (for...
☆ 0查看技能
GitHub
sqlmodel
SQLModel ORM skill for Python database operations combining SQLAlchemy power with Pydantic validation. Use when: (1) Defining database models with type hints, (2) Setting up async database connections, (3) Crea...
☆ 0查看技能
GitHub
sqlmodel
SQLModel - Pydantic + SQLAlchemy combined. This skill should be used when building FastAPI apps with database, creating ORM models, data validation with database persistence, or any Python project needing both...
☆ 0查看技能
GitHub
sqlmodel
SQLModel ORM skill for Python database operations. Use when defining database models, creating tables, managing sessions, writing CRUD operations, or integrating with FastAPI. Triggers include "create model", "...
☆ 0查看技能
GitHub
snowflake-query
Execute SQL queries against Snowflake data warehouse using Python connector. Supports password, key-pair, and SSO/OAuth authentication. Use for ad-hoc queries, data extraction, and schema exploration. Output in...
☆ 0查看技能
GitHub
mastering-postgresql
PostgreSQL development for Python with full-text search (tsvector, tsquery, BM25 via pg_search), vector similarity (pgvector with HNSW/IVFFlat), JSONB and array indexing, and production deployment. Use when cre...
☆ 0查看技能
热门分类
默认按已收录数据中的 GitHub 仓库 Stars 排序。Stars 属于来源仓库，同一仓库的多个技能可能共享相同数值；它反映仓库关注度，不代表单个技能的安装量或质量评分。