Database Schema
CheckedHelps with database, schema design as part of working with databases and data persistence workflows.
Install on your platform
Showing Claude Code. One command installs this skill into any of the agents below.
- 1
Run this in your project
terminal$ npx skills add alinaqi/maggy --skill database-schema -a claude-code Uses the open-source
skillsCLI and needs Node.js. Add-gto install it for your user instead of this project.
What we know about this skill
Publisher
alinaqi
Taken from the source listing. We haven't verified who controls this account.
Install target
Live repository
Not pinned. Installing fetches whatever the repository holds at the time you run the command.
Automated safety checks
This skill passed all 6 checks. We read its files at one commit and looked for the things that make a skill dangerous to run — not for whether it works.
Declares what it does: passed
SKILL.md parses and declares a name and a description.
SKILL.md exists, its frontmatter parses, and it declares a name and a description.
No undeclared network calls: passed
Makes no network calls.
Every host the skill dials — from its scripts, its config endpoints or the commands it tells the agent to run — is either well-known package and API infrastructure or declared in its own frontmatter. Links in documentation are not counted.
No obfuscated payloads: passed
No encoded or obfuscated payloads.
No base64, hex or compressed blob is decoded and then executed, and no encoded shell commands.
No credential access: passed
Reads no keys, tokens, keychains or credential files.
Neither the code nor the SKILL.md instructions read SSH keys, cloud credentials, keychains, token stores, browser cookie databases or dotfiles that hold secrets.
No pipe-to-shell installers: passed
No pipe-to-shell or download-and-run installers.
No `curl … | sh` pattern, in the code or in the instructions, that runs code fetched at run time.
Pinned to a commit: passed
Scanned alinaqi/claude-bootstrap at 72a456e6cc.
The exact upstream commit SHA that was scanned is recorded, so the result refers to specific bytes.
- Commit
- 72a456e6cc
- Manifest
- skills/database-schema/SKILL.md
- Scanned
- 1 file, 346 lines
About this skill
The database-schema skill enables AI agents to interact with and understand database structures, allowing them to query data based on specific table definitions. It facilitates tasks like retrieving schema metadata, validating column types, and generating SQL queries tailored to your existing database architecture.
When to use it
- You need an agent to automatically generate
SELECTstatements that join multiple tables correctly. - Your team requires a tool to validate if new data payloads conform to the current database constraints before ingestion.
- You want to document complex relationships between tables without manually writing out the schema definitions.
Key capabilities
- Schema Discovery: Automatically retrieves table names, column definitions, and data types from connected databases.
- Query Generation: Constructs valid SQL queries based on retrieved schema information.
- Relationship Mapping: Identifies foreign keys and joins to understand how tables relate to one another.
Example prompts
- "Analyze the
usersandorderstables in my PostgreSQL database and write a query to find total spending per user." - "What are the data types for all columns in the
productstable, and does it have a foreign key linking to thecategoriestable?" - "Generate an
INSERTstatement for theinventorytable that respects the existing schema constraints."
Tips & gotchas
Ensure your AI agent has explicit read permissions on the target database before attempting schema discovery. This skill relies on accurate metadata; if your database uses dynamic schemas or lacks proper indexing, query generation may require additional manual verification.