database

Scaffolds SQLite, Postgres, or MongoDB connections, schemas, and query modules for application builds.

1|9|Updated Jul 11, 2026
One-click install
npx skills add https://github.com/agenticgogol/Edureka_Coding_Agent_Enabled_Demo_11Jul --skill database-agenticgogol
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/agenticgogol/Edureka_Coding_Agent_Enabled_Demo_11Jul/tree/main/.claude/skills/database
Command: npx skills add https://github.com/agenticgogol/Edureka_Coding_Agent_Enabled_Demo_11Jul --skill database-agenticgogol

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? When a project brief or design document calls for structured storage, developers often improvise inconsistent connection code, skip schema definitions, or silently swap the chosen database for a more familiar one. This Skill standardizes how SQLite, Postgres, or MongoDB is scaffolded so the store named in the design is the store that gets built. ## Core Features & Use Cases - Store-specific scaffolding: Creates a single small module (e.g. db.py) exposing only the operations the app needs, such as get(id), insert(record), and query(filter), so callers never touch the driver directly. - Grounded recommendations: During requirements interviews, recommends SQLite for local-first demos, Postgres only for concurrent writers or relational integrity needs, and MongoDB only for document-shaped records. - No mock mode enforcement: Treats a missing DATABASE_URL or MONGODB_URI as a hard stop rather than silently falling back to SQLite. - Use Case: A teaching demo brief specifies Postgres for a multi-user task tracker. The Skill adds psycopg[binary], writes a schema.sql with CREATE TABLE statements, scaffolds db.py, and documents reset steps in data/README.md. ## Quick Start Use the database skill to scaffold the Postgres connection, schema, and query module specified in my design document.

Frequently Asked Questions about database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I choose between SQLite, Postgres, and MongoDB for a Python app?▼

Choose SQLite for local-first, single-process apps with no concurrent writers since it ships in the Python stdlib. Pick Postgres only for concurrent writers or enforced relational integrity, and MongoDB only for schema-variable, document-shaped records without relational joins.

How do I scaffold a database module in Python without exposing the driver?▼

Create one small module such as db.py that exposes only the operations the app needs, like get(id), insert(record), and query(filter). Callers use these functions and never import sqlite3, psycopg, or pymongo directly.

What happens if the DATABASE_URL environment variable is missing?▼

A missing DATABASE_URL or MONGODB_URI is treated as a hard stop, the same as a missing LLM API key. The build halts rather than falling back to SQLite, because Postgres and MongoDB calls are real network calls with no mock mode.

Does MongoDB need a schema like SQLite or Postgres?▼

MongoDB requires no schema or migration, but the expected document shape should still be documented in data/README.md so ingestion and query code stay consistent. SQLite and Postgres need an explicit CREATE TABLE, either inline at startup or in a schema.sql file.

When should I not use Postgres for a demo project?▼

Avoid Postgres for teaching demos or single-process local apps where its concurrent-writer and multi-client strengths are unused. Recommending it for production-readiness alone is over-engineering when SQLite handles the usecase with zero external services.