Database Schema Awareness

by alinaqi

Database Schema Awareness is an AI Engineering skill for Claude Code, published by alinaqi in maggy.

704 stars57 forkson alinaqi/maggyAdded 2026/08/23Repository updated 2026/08/18

View source on GitHub Download repo ZIP

ai-codingclaudeclaude-codedeveloper-toolsproject-initializationpythonreactsecuritytypescript

Install in seconds

Install Database Schema Awareness

Copy Database Schema Awareness into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.

terminal

npx degit https://github.com/alinaqi/maggy/tree/main/skills/database-schema ~/.claude/skills/database-schema

Requires Node.js. Downloads this skill only — not the rest of the repository — into your Claude Code skills folder.

Without Node.js

git clone https://github.com/alinaqi/maggy.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file: skills/database-schema/SKILL.md in alinaqi/maggy
Installs to: ~/.claude/skills/database-schema
Collection: One of 25 skills cataloged from this repository
Category: AI Engineering — 2451 skills

What Database Schema Awareness does

Database Schema Awareness reads the schema before database work so you verify columns, types, and relationships before writing queries or models. Use it to prevent column-name and type mismatches and to guide generated types.

Database Schema Awareness is cataloged under AI Engineering on DirSkills. Database Schema Awareness comes from a repository tagged ai-coding, claude, claude-code, developer-tools and project-initialization.

Documentation

README

Excerpt

Database Schema Awareness Skill

Problem: Claude forgets schema details mid-session - wrong column names, missing fields, incorrect types. TDD catches this at runtime, but we can prevent it earlier.

Core Rule: Read Schema Before Writing Database Code

MANDATORY: Before writing ANY code that touches the database:

┌─────────────────────────────────────────────────────────────┐
│  1. READ the schema file (see locations below)              │
│  2. VERIFY columns/types you're about to use exist          │
│  3. REFERENCE schema in your response when writing queries  │
│  4. TYPE-CHECK using generated types (Drizzle/Prisma/etc)   │
└─────────────────────────────────────────────────────────────┘

If schema file doesn't exist → CREATE IT before proceeding.

This is the opening of the README. Read the full README on GitHub.

Frequently asked about Database Schema Awareness

What else does alinaqi publish alongside Database Schema Awareness?
Database Schema Awareness is one of 25 skills that DirSkills catalogs from alinaqi/maggy, the repository it ships in. Its siblings there include AI Engine Optimization, AI Models Reference and AWS Aurora. Each one is a separate skill with its own page in this directory, installs the same way Database Schema Awareness does, and is maintained by alinaqi in that same repository. The rest of the collection is listed on the alinaqi/maggy page.
How does Database Schema Awareness compare to other AI Engineering skills?
Database Schema Awareness ranks #1715 by stars among the 2451 AI Engineering skills in this catalog. The most-starred ones next to it are Architecture Decision Records, AI-First Engineering and Agentic OS. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of Database Schema Awareness against them. Open each page to compare what they document and how they install.