Create and manage Replit PostgreSQL databases and execute SQL queries with safety checks.
npx skills add https://github.com/BotchaVarun/EduBot --skill database-botchavarun
Please help me install this Agent Skill. Skill: database Source: https://github.com/BotchaVarun/EduBot/tree/main/.local/skills/database Command: npx skills add https://github.com/BotchaVarun/EduBot --skill database-botchavarun
High-intent search queries and answers about installing and using this skill.
Call checkDatabase() first to see if one is provisioned, then call createDatabase() if needed. The creation sets environment variables like DATABASE_URL, PGHOST, and PGPASSWORD automatically, so your application can connect immediately.
Use executeSql with the environment parameter set to production. Production queries run read-only against a replica, so only SELECT statements are allowed, and INSERT, UPDATE, DELETE, and DDL statements will fail.
Yes, executeSql supports bigquery, databricks, and snowflake as target values alongside the default replit_database. You can pass a sampleSize parameter to limit warehouse query results, but production environment queries only work with replit_database.
Destructive queries like DROP and TRUNCATE are blocked through the skill callback path as a safety measure. Mutating queries are also blocked in Planning mode, and modifications to Stripe schema tables are always prevented.
The built-in PostgreSQL database is preferred because it supports rollbacks and integrates directly with Replit. Only use external database services when you have specific requirements the built-in option cannot meet.
coco-deDesign Serverpod database schemas in protocol YAML with PostgreSQL.
AsmayaseenConnect serverless apps to Neon PostgreSQL using HTTP and pool modes.
thehivegroup-aiManage PostgreSQL schema design, migrations, and query optimization with psycopg2.
SSujitXProvision and manage containerized database instances in Docker environments.
