database

Provision PostgreSQL databases and execute SQL queries with environment-aware safety checks.

Updated Apr 18, 2026
One-click install
npx skills add https://github.com/samibrahmi/instanotes-api --skill database-samibrahmi
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/samibrahmi/instanotes-api/tree/main/newcontent/skills/database
Command: npx skills add https://github.com/samibrahmi/instanotes-api --skill database-samibrahmi

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL databases can be provisioned, monitored, and queried with built-in safeguards to prevent production disruptions, accidental data loss, and misconfigurations. This skill centralizes database lifecycle tasks, enforces proper access controls, and ensures safe query execution across development and production environments.

Core Features & Use Cases

  • Check database provisioning and connectivity with checkDatabase()
  • Create or verify a PostgreSQL database with createDatabase()
  • Execute SQL queries with safety checks via executeSql(), including environment-aware read-only production mode and warehouse query support
  • Run read-only production queries against a replica and operate against development databases with proper safeguards
  • Query data warehouses (BigQuery, Databricks, Snowflake) when needed, with explicit guidance on connectors
  • Enforce best practices like parameterized queries and query order to avoid destructive changes

Quick Start

Check the database status, then create the database if needed, and run a safe query against the development database.

Frequently Asked Questions about database

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

FAQPage Schema
How do I safely run SQL queries against a production PostgreSQL database?

Safely run SQL queries against production PostgreSQL databases by using environment-aware read-only mode and query safety checks. This enforces isolation to prevent accidental data loss and avoids destructive changes during production database execution.

What is the best way to provision and check PostgreSQL database connectivity?

Provision and verify PostgreSQL database connectivity by executing status checks to ensure the database is running. This lifecycle management process centralizes setup and confirms your environment is properly configured before executing queries.

Can I query data warehouses like BigQuery or Snowflake using this database skill?

You can query data warehouses like BigQuery, Databricks, and Snowflake using this database skill. It provides explicit guidance on connectors to safely execute and manage warehouse queries when needed alongside PostgreSQL operations.

Does this database skill isolate development and production environments?

This database skill isolates development and production environments to prevent misconfigurations and disruptions. It enforces strict access controls, allowing full execution against development databases while restricting production to read-only replica queries.

Why do my PostgreSQL database queries fail safety checks?

PostgreSQL database queries fail safety checks when they lack proper parameterization or violate enforced query order rules. These safeguards actively prevent destructive changes and ensure structured return data with status and messages.

How do I execute parameterized SQL queries in a development database?

Execute parameterized SQL queries in a development database by applying built-in safety checks and best practices. This ensures structured return data with status and messages while preventing accidental data loss during development execution.