schema-alignment
Detect Database Schema Drift
Database schemas and application models can diverge, causing runtime errors and failed deployments. This skill compares migrations, schemas, and ORM models to produce prioritized alignment reports.
Install with my Agent
Copy this request to your Agent. It includes the canonical Skill page and manifest.
Review the Skillstore skill "schema-alignment" from https://skillstore.io/skills/consiliency-schema-alignment.md and its manifest at https://skillstore.io/api/skills/consiliency-schema-alignment/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.Your Agent should still show its plan and request any confirmation required by the security policy.
Agent-readable resources
Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.
Test it
Using "schema-alignment". Compare SQLAlchemy models with Alembic migrations for the users table.
Expected outcome:
- High: users.retry_count exists in migrations but is missing from the model.
- Medium: users.email allows 255 characters in the database but is unbounded in the model.
- Suggested action: update the model and generate a reviewed migration if needed.
Using "schema-alignment". Check a Prisma schema for missing migrations.
Expected outcome:
Low: User.preferences exists in the model, but no matching migration was found. Generate and review a migration before deployment.
Using "schema-alignment". Review nullability and foreign keys for orders.
Expected outcome:
Medium: orders.user_id is required in the database, but the model allows null. Align nullability and verify the relationship constraint.
Security Audit
SafeAll 50 static findings are false positives caused by Markdown fences, inline code, schema examples, and ordinary ORM identifiers. No prompt injection, credential exfiltration, network request, or executable implementation was found in the documentation-only skill.
Risk Factors
🔑 Env variables (1)
⚙️ External commands (35)
🌐 Network access (1)
Share & cite this report
Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.
Copy report link
https://skillstore.io/skills/consiliency-schema-alignment/audits/10?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_reportMarkdown badge
[](https://skillstore.io/skills/consiliency-schema-alignment?utm_source=security_passport_badge)HTML badge
<a href="https://skillstore.io/skills/consiliency-schema-alignment?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/consiliency-schema-alignment/security.svg" alt="Skillstore security assessment" loading="lazy"></a>Embed card
<iframe src="https://skillstore.io/embed/skills/consiliency-schema-alignment.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>Academic citations (APA · BibTeX · CFF)
APA citation
Consiliency. (2026). schema-alignment security audit report (audit version 10) [Author version unspecified]. Skillstore. https://skillstore.io/skills/consiliency-schema-alignment/audits/10BibTeX citation
@techreport{consiliency-consiliency-schema-alignment-2026,
author = {Consiliency},
title = {schema-alignment security audit report (audit version 10)},
institution = {Skillstore},
year = {2026},
number = {10},
url = {https://skillstore.io/skills/consiliency-schema-alignment/audits/10},
note = {Author version unspecified}
}CITATION.cff
cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "schema-alignment security audit report (audit version 10)"
version: "unspecified"
type: report
authors:
- name: "Consiliency"
date-released: "2026-07-13"
url: "https://skillstore.io/skills/consiliency-schema-alignment/audits/10"
identifiers:
- type: other
value: "skillstore:consiliency-schema-alignment:audit:10"
description: "Skillstore immutable audit report identifier"
Skillstore Score
Why this score Evidence Confidence: HighWhat You Can Build
Validate model changes
Compare edited ORM models with migrations before opening a pull request.
Audit database drift
Find mismatched columns, constraints, relationships, and types across the application and database.
Check deployment readiness
Review pending schema differences and missing migrations before a release reaches production.
Try These Prompts
Inspect this project for schema drift. Detect the ORM, compare models with migrations, and report medium or higher issues.
Compare the users and orders tables with their ORM models. Include missing fields, type mismatches, nullability, defaults, and foreign keys.
Compare recent model changes with Alembic or Prisma migrations. Identify missing migrations and propose fixes without applying database changes.
Use migrations as the baseline and compare models plus the read-only live schema. Rank drift, explain impact, and propose reversible remediation steps.
Best Practices
- Prefer migration history as the baseline when it is complete and authoritative.
- Use read-only database credentials for live schema inspection.
- Review generated fixes and test migrations in an isolated environment.
Avoid
- Do not apply generated migrations directly to production.
- Do not infer the live schema only from ORM models.
- Do not dismiss type or nullability mismatches because tests currently pass.
Frequently Asked Questions
Which ORMs does this skill support?
Does it modify my database?
Can it inspect a live database?
What drift can it detect?
Can it run in continuous integration?
Are generated fixes ready for production?
Developer Details
Author
ConsiliencyLicense
MIT
Skillstore revision
r1
Version notice
The author did not declare a version.
Repository
https://github.com/Consiliency/treesitter-chunker/tree/main/.ai-dev-kit/skills/schema-alignmentRef
635f69fb8d2f4e6330ba47a4e5a0fb239c04d110
Maintenance freshness
7/18/2026
Usage
6 downloads · 226 views
File structure