Build Reliable Python Database Layers
Database layers often suffer from inconsistent sessions, schemas, and query patterns. This skill provides reusable SQLModel and SQLAlchemy examples for connections, repositories, migrations, optimization, and tests.
Stop for confirmation before installing.
Review the plan and obtain explicit user consent before changing files.
Copy this request to your Agent. It includes the canonical Skill page and manifest.
Review the Skillstore skill "database" from https://skillstore.io/skills/azeem-2-database.md and its manifest at https://skillstore.io/api/skills/azeem-2-database/manifest. Verify the artifact. Stop and obtain explicit user consent before installing or changing files.Your Agent should still show its plan and request any confirmation required by the security policy.
Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.
Using "database". Review a task repository that lists records by owner and supports pagination.
Expected outcome:
Using "database". Plan a migration that adds a required status field to a large table.
Expected outcome:
Most alerts are false positives caused by SQLModel Session.exec and Markdown fences; they do not invoke Python, processes, or shells. The production example retains a default database credential, and generic repository writes accept unrestricted model fields.
These are real local capabilities that may be expected for this skill, so they require review but are not counted as confirmed malicious behavior.
Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.
https://skillstore.io/skills/azeem-2-database/audits/12?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report[](https://skillstore.io/skills/azeem-2-database?utm_source=security_passport_badge)<a href="https://skillstore.io/skills/azeem-2-database?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/azeem-2-database/security.svg" alt="Skillstore security assessment" loading="lazy"></a><iframe src="https://skillstore.io/embed/skills/azeem-2-database.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>Azeem-2. (2026). database security audit report (audit version 12) [Author version unspecified]. Skillstore. https://skillstore.io/skills/azeem-2-database/audits/12@techreport{azeem-2-azeem-2-database-2026,
author = {Azeem-2},
title = {database security audit report (audit version 12)},
institution = {Skillstore},
year = {2026},
number = {12},
url = {https://skillstore.io/skills/azeem-2-database/audits/12},
note = {Author version unspecified}
}cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "database security audit report (audit version 12)"
version: "unspecified"
type: report
authors:
- name: "Azeem-2"
date-released: "2026-07-23"
url: "https://skillstore.io/skills/azeem-2-database/audits/12"
identifiers:
- type: other
value: "skillstore:azeem-2-database:audit:12"
description: "Skillstore immutable audit report identifier"
Each author remains a separate installable skill. The recommended variant is ranked by Skillstore evidence.
Why this variant is first
sickn33-database
2026-08-21
azeem-2-database
2026-08-21
Define models, sessions, repositories, and indexes for a new Python service.
Assess pooling, migrations, query plans, and PostgreSQL monitoring before deployment.
Create fixtures and test cases for transactions, repositories, pagination, and tenant boundaries.
Design SQLModel models for [domain]. Include field types, relationships, constraints, and essential indexes. Explain each design choice.
Create an AsyncSession repository for [model]. Include typed create and update inputs, pagination, transactions, rollback, and an explicit field allowlist.
Review this migration plan for [change]. Identify locking, data loss, rollback, index, and deployment risks. Propose safer steps.
Audit this database design for [workload]. Analyze query plans, pool sizing, tenant isolation, authorization boundaries, monitoring, and failure recovery.
Author
Azeem-2License
MIT
Skillstore revision
r3
Version notice
The author did not declare a version.
Ref
89edfdc710d0846129dcee6a929477b04f08052c
Maintenance freshness
7/24/2026
Usage
8 downloads · 265 views
File structure
📄 SKILL.md
Draft Project Constitutions from Documents
Teams often hide mission, values, and governance rules across scattered documents. This skill extracts those elements and turns them into a clear project constitution.
Design Distinctive Frontend Interfaces
Generic web interfaces feel interchangeable and may miss the user's brand or product context. This skill guides Claude, Codex, and Claude Code to design polished, functional frontends with a clear visual direction.
Automate PDF Processing
PDF workflows often require extraction, form filling, and file conversion across several tools. This skill gives Claude, Codex, and Claude Code structured steps and scripts for common PDF tasks.
Create Slack-Ready Animated GIFs
Slack GIFs need compact dimensions, smooth motion, and controlled file sizes. This skill provides local Python utilities for drawing, animation, optimization, and validation.
Co-author Strong Documentation
Writing complex docs is hard when context, structure, and reader assumptions are unclear. This skill guides context capture, section drafting, iterative edits, and reader testing.
Draft Internal Company Updates
Teams lose time turning scattered updates into clear internal messages. This skill guides Claude, Codex, and Claude Code to draft concise newsletters, 3P updates, FAQs, and general communications.
Optimize Supabase Postgres Performance
by supabase
Slow queries and schema drift can make Postgres apps hard to scale. This skill gives AI agents Supabase-backed rules for indexes, RLS, pooling, and diagnostics.
Design Production Database Schemas
by softaworks
Teams need schemas that preserve data integrity and stay fast as products grow. This skill turns domain requirements into SQL or MongoDB designs with indexes, constraints, and migration guidance.
Build SQL Queries From Plain Language
by zhangchenlai-dev
Teams often spend time turning data questions into reliable SQL. This skill converts plain language into SQL guidance with execution-plan review and optimization advice.
Generate SQL Queries for DBX Studio
by Dbxstudio
Database users need reliable SQL that matches their connection type and schema. This skill guides Claude, Codex, and Claude Code to inspect schemas, write read-only queries, and explain results clearly.
Explore Database Schemas in DBX Studio
by Dbxstudio
Database teams often need a quick view of tables, relationships, and data quality before analysis. This skill guides Claude, Codex, or Claude Code through a structured DBX Studio profiling workflow.
Design PostgreSQL Schemas With Best Practices
by sickn33
PostgreSQL schema design can fail when data types, constraints, indexes, and migrations lack workload context. This skill turns entities, access patterns, and scale targets into PostgreSQL-specific design guidance.