Skip to content

aiskillstore/marketplace / skills/abdulsamad94/database-orm

database-orm

Verified

Interaction with NeonDB Postgres using Drizzle ORM.

FileKindSize
SKILL.mdskill md1.0 KB
skill-report.jsonconfig17.7 KB

skill-report.json

View on GitHub
{
  "schema_version": "2.0",
  "meta": {
    "generated_at": "2026-07-18T09:43:43.459Z",
    "slug": "abdulsamad94-database-orm",
    "source_url": "https://github.com/AbdulSamad94/Hackhaton-SpecsKitPlus/tree/master/.claude/skills/database",
    "source_ref": "master",
    "model": "claude",
    "analysis_version": "3.0.0",
    "source_type": "community",
    "content_hash": "4ae21300867000940be8e59bbecce28e982a91efbdc22c71c219e229c7d5eebf",
    "tree_hash": "3e6f64b7d986ae18a8e8c2fc1659d4871fd5cd8bf23297d0be6be5c3d4dbe896",
    "provenance": {
      "model_effective": "claude",
      "fallback_chain": [
        {
          "agent": "codex",
          "outcome": "failed",
          "error": "2026-07-18T09:43:43.589417Z ERROR codex_models_manager::manager: failed to refresh available models: Missing environment variable: `HELM_API_KEY`.\n2026-07-18T09:43:43.611790Z ERROR codex_models_manage…"
        },
        {
          "agent": "claude",
          "outcome": "success"
        }
      ],
      "analysis_version": "3.0.0"
    }
  },
  "skill": {
    "name": "Database & ORM",
    "description": "Guides Neon Postgres connections, Drizzle ORM schemas, queries, and migrations.",
    "summary": "Use Neon Postgres with Drizzle ORM for database setup and common operations.",
    "icon": "📦",
    "author": "AbdulSamad94",
    "license": "MIT",
    "category": "data",
    "tags": [
      "postgres",
      "neon",
      "drizzle-orm",
      "database",
      "migrations"
    ],
    "supported_tools": [
      "claude",
      "codex",
      "claude-code"
    ],
    "risk_factors": [
      "external_commands",
      "env_access"
    ]
  },
  "security_audit": {
    "risk_level": "safe",
    "is_blocked": false,
    "safe_to_publish": true,
    "analysis_status": "ok",
    "summary": "All 14 static findings are false positives. Markdown inline code and fenced TypeScript examples were misidentified as shell execution, while DATABASE_URL is used only to configure the Neon driver. No command execution, environment-file reading, credential disclosure, or prompt-injection intent was found.",
    "remediation": [],
    "risk_factor_evidence": [
      {
        "factor": "external_commands",
        "evidence": [
          {
            "file": "SKILL.md",
            "line_start": 11,
            "line_end": 11
          },
          {
            "file": "SKILL.md",
            "line_start": 14,
            "line_end": 14
          },
          {
            "file": "SKILL.md",
            "line_start": 16,
            "line_end": 22
          },
          {
            "file": "SKILL.md",
            "line_start": 22,
            "line_end": 25
          },
          {
            "file": "SKILL.md",
            "line_start": 25,
            "line_end": 26
          },
          {
            "file": "SKILL.md",
            "line_start": 26,
            "line_end": 26
          },
          {
            "file": "SKILL.md",
            "line_start": 27,
            "line_end": 27
          },
          {
            "file": "SKILL.md",
            "line_start": 32,
            "line_end": 42
          },
          {
            "file": "SKILL.md",
            "line_start": 42,
            "line_end": 45
          },
          {
            "file": "SKILL.md",
            "line_start": 45,
            "line_end": 46
          }
        ]
      },
      {
        "factor": "env_access",
        "evidence": [
          {
            "file": "SKILL.md",
            "line_start": 20,
            "line_end": 20
          },
          {
            "file": "SKILL.md",
            "line_start": 20,
            "line_end": 20
          },
          {
            "file": "SKILL.md",
            "line_start": 20,
            "line_end": 20
          }
        ]
      }
    ],
    "static_findings": [
      {
        "id": "external_commands:SKILL.md:11:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 11,
        "line_end": 11,
        "snippet": "- **Driver**: `@neondatabase/serverless`"
      },
      {
        "id": "external_commands:SKILL.md:14:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 14,
        "line_end": 14,
        "snippet": "The database connection is initialized in `db/index.ts`."
      },
      {
        "id": "external_commands:SKILL.md:16:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 16,
        "line_end": 22,
        "snippet": "```ts"
      },
      {
        "id": "external_commands:SKILL.md:22:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 22,
        "line_end": 25,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:25:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 25,
        "line_end": 26,
        "snippet": "Schema definitions are in `db/schema.ts`."
      },
      {
        "id": "external_commands:SKILL.md:26:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 26,
        "line_end": 26,
        "snippet": "- `users`, `sessions`, `accounts`, `verifications`: Auth tables."
      },
      {
        "id": "external_commands:SKILL.md:27:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 27,
        "line_end": 27,
        "snippet": "- `analyses`, `chatbot_history`: App specific tables."
      },
      {
        "id": "external_commands:SKILL.md:32:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 32,
        "line_end": 42,
        "snippet": "```ts"
      },
      {
        "id": "external_commands:SKILL.md:42:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 42,
        "line_end": 45,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:45:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 45,
        "line_end": 46,
        "snippet": "- Generate: `npx drizzle-kit generate`"
      },
      {
        "id": "env_access:SKILL.md:20:environment-variable-access-dot-notation",
        "category": "env_access",
        "severity": "low",
        "pattern": "Environment variable access (dot notation)",
        "file": "SKILL.md",
        "line_start": 20,
        "line_end": 20,
        "snippet": "const sql = neon(process.env.DATABASE_URL!);"
      },
      {
        "id": "env_access:SKILL.md:20:environment-variable-object",
        "category": "env_access",
        "severity": "low",
        "pattern": "Environment variable object",
        "file": "SKILL.md",
        "line_start": 20,
        "line_end": 20,
        "snippet": "const sql = neon(process.env.DATABASE_URL!);"
      },
      {
        "id": "env_access:SKILL.md:20:database-connection-strings",
        "category": "env_access",
        "severity": "high",
        "pattern": "Database connection strings",
        "file": "SKILL.md",
        "line_start": 20,
        "line_end": 20,
        "snippet": "const sql = neon(process.env.DATABASE_URL!);"
      },
      {
        "id": "sensitive:SKILL.md:20:environment-file-access",
        "category": "sensitive",
        "severity": "high",
        "pattern": "Environment file access",
        "file": "SKILL.md",
        "line_start": 20,
        "line_end": 20,
        "snippet": "const sql = neon(process.env.DATABASE_URL!);"
      }
    ],
    "finding_verdicts": [
      {
        "id": "external_commands:SKILL.md:11:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The backticks format a package name in Markdown. They do not invoke a shell or execute code."
      },
      {
        "id": "external_commands:SKILL.md:14:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The backticks format a file path in explanatory Markdown. No command is present or executed."
      },
      {
        "id": "external_commands:SKILL.md:16:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is the start of a fenced TypeScript example, not Ruby or shell backtick execution."
      },
      {
        "id": "external_commands:SKILL.md:22:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This closes a Markdown code fence. It cannot execute a command."
      },
      {
        "id": "external_commands:SKILL.md:25:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The backticks format a schema file path in documentation. There is no executable shell syntax."
      },
      {
        "id": "external_commands:SKILL.md:26:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The backticks format database table names in Markdown. They do not execute external commands."
      },
      {
        "id": "external_commands:SKILL.md:27:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The backticks format database table names in Markdown. They do not execute external commands."
      },
      {
        "id": "external_commands:SKILL.md:32:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is the start of a fenced TypeScript query example, not shell execution."
      },
      {
        "id": "external_commands:SKILL.md:42:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This closes a Markdown code fence. It cannot execute a command."
      },
      {
        "id": "external_commands:SKILL.md:45:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The line documents a Drizzle CLI command as text. The skill contains no mechanism to run it automatically."
      },
      {
        "id": "env_access:SKILL.md:20:environment-variable-access-dot-notation",
        "verdict": "false_positive",
        "confidence": 0.96,
        "reason": "The example reads DATABASE_URL solely to initialize the documented database driver. It does not expose or transmit the value."
      },
      {
        "id": "env_access:SKILL.md:20:environment-variable-object",
        "verdict": "false_positive",
        "confidence": 0.96,
        "reason": "process.env is used for one standard connection configuration value. No broad environment enumeration occurs."
      },
      {
        "id": "env_access:SKILL.md:20:database-connection-strings",
        "verdict": "false_positive",
        "confidence": 0.96,
        "reason": "DATABASE_URL is referenced as a configuration input and no connection string is hardcoded, logged, or sent elsewhere."
      },
      {
        "id": "sensitive:SKILL.md:20:environment-file-access",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The example accesses process.env at runtime and does not read an environment file."
      }
    ],
    "semantic_findings": [],
    "critical_findings": [],
    "high_findings": [],
    "medium_findings": [],
    "low_findings": [],
    "dangerous_patterns": [],
    "files_scanned": 1,
    "total_lines": 47,
    "audit_model": "claude",
    "audited_at": "2026-07-18T09:43:43.459Z",
    "agent_auto_install_policy": "allowed",
    "manual_install_policy": "allowed"
  },
  "content": {
    "user_title": "Connect Neon Postgres with Drizzle ORM",
    "value_statement": "Database setup can be difficult when connection, schema, and migration steps are unclear. This skill provides a focused reference for Neon Postgres and Drizzle ORM workflows.",
    "seo_keywords": [
      "Claude",
      "Codex",
      "Claude Code",
      "Neon Postgres",
      "Drizzle ORM",
      "PostgreSQL",
      "database migrations",
      "serverless database",
      "TypeScript ORM"
    ],
    "actual_capabilities": [
      "Explains the Neon serverless Postgres and Drizzle ORM stack.",
      "Shows a DATABASE_URL-based Neon driver connection example.",
      "Identifies the expected database connection and schema file locations.",
      "Lists the documented authentication and application table groups.",
      "Provides select and insert query examples using Drizzle ORM.",
      "Documents Drizzle Kit generation and push migration commands."
    ],
    "limitations": [
      "It does not create database files or execute migrations automatically.",
      "It does not provide schema definitions beyond the listed table names.",
      "It does not validate database credentials or network connectivity.",
      "It does not cover query authorization, backups, or production monitoring."
    ],
    "use_cases": [
      {
        "title": "Set up a Neon connection",
        "description": "Review the documented driver and environment-variable pattern before configuring a TypeScript service.",
        "target_user": "Backend developer"
      },
      {
        "title": "Review a Drizzle data layer",
        "description": "Use the file layout and query examples to compare an existing project with the expected ORM structure.",
        "target_user": "Technical lead"
      },
      {
        "title": "Prepare database migrations",
        "description": "Identify the documented Drizzle Kit commands for generating and applying schema changes.",
        "target_user": "DevOps engineer"
      }
    ],
    "prompt_templates": [
      {
        "title": "Understand the stack",
        "scenario": "Beginner",
        "prompt": "Explain the Neon Postgres and Drizzle ORM stack described by this skill in simple steps."
      },
      {
        "title": "Configure a connection",
        "scenario": "Intermediate",
        "prompt": "Show how the skill connects Drizzle ORM to Neon using DATABASE_URL, and explain each imported package."
      },
      {
        "title": "Plan a schema update",
        "scenario": "Advanced",
        "prompt": "Use this skill to outline a safe workflow for changing a Drizzle schema and preparing a migration."
      },
      {
        "title": "Review database operations",
        "scenario": "Advanced",
        "prompt": "Compare my proposed Drizzle select and insert operations with the patterns documented in this skill. Identify missing validation or authorization concerns."
      }
    ],
    "output_examples": [
      {
        "input": "How does this skill connect to Neon?",
        "output": [
          "It uses the Neon serverless driver.",
          "It reads DATABASE_URL to create a SQL client.",
          "It passes that client to Drizzle ORM."
        ]
      },
      {
        "input": "What migration commands are documented?",
        "output": [
          "Generate migrations with Drizzle Kit.",
          "Apply changes with the documented push command or a project migration script.",
          "Review generated changes before applying them to a production database."
        ]
      }
    ],
    "best_practices": [
      "Store DATABASE_URL in the deployment environment and never commit it to source control.",
      "Review generated migrations before applying them to shared or production databases.",
      "Add authorization and input validation around application queries."
    ],
    "anti_patterns": [
      "Do not hardcode database credentials in source files or prompts.",
      "Do not apply schema pushes to production without review and backups.",
      "Do not treat the example queries as complete authorization controls."
    ],
    "faq": [
      {
        "question": "Which database does this skill cover?",
        "answer": "It covers Neon, a serverless Postgres database."
      },
      {
        "question": "Which ORM does it use?",
        "answer": "It uses Drizzle ORM with the Neon HTTP driver."
      },
      {
        "question": "Where does the connection string come from?",
        "answer": "The example reads DATABASE_URL from the runtime environment."
      },
      {
        "question": "Does the skill run migrations automatically?",
        "answer": "No. It documents Drizzle Kit commands but does not execute them."
      },
      {
        "question": "What queries are included?",
        "answer": "It includes simple select and insert examples."
      },
      {
        "question": "Does it secure application data access?",
        "answer": "No. You must add authorization, validation, and operational safeguards in your application."
      }
    ]
  },
  "file_structure": [
    {
      "name": "SKILL.md",
      "type": "file",
      "path": "SKILL.md",
      "lines": 47
    }
  ]
}
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall