OneLinersCommand workbench
Guides
Operational guides

Complete procedures with a way back.

Searchable, versioned procedures with prerequisites, verification, concrete output, and rollback.

Guides
243
Favorites
0
243 launch guides · 2601 reviewed steps
14 of 243 guides

Databases & Data · Incident Response & Troubleshooting

Fix PostgreSQL relation does not exist: database, schema and search_path

Trace PostgreSQL SQLSTATE 42P01 from the failing application connection to the exact database, schema and identifier. Distinguish missing migrations from name-resolution and privilege problems, then prove a narrow correction without creating a guessed table or exposing application data.
Save to collectionCreate a collection in the sidebar first.
caution40 minintermediate7 stepsPostgreSQL

Databases & Data · Identity & Access · Incident Response & Troubleshooting

Fix PostgreSQL permission denied for schema public or table

Diagnose and repair PostgreSQL permission errors without granting broad roles or changing object ownership. This guide separates database connection, schema USAGE and CREATE, table privileges, sequence access, role inheritance, default privileges, and row-level security so an application receives only the rights it actually needs.
Save to collectionCreate a collection in the sidebar first.
caution45 minintermediate10 stepsPostgreSQL

AI/ML · Databases & Data · Security

Build a read-only PostgreSQL analytics bot with reviewed SQL and chart output

Build a local-first analytics assistant that discovers only curated PostgreSQL views, asks OpenAI for a structured SELECT proposal, validates a conservative SQL subset, requires a human to approve the exact query, enforces a restricted database role and read-only transaction, limits time and rows, and emits local table or chart JSON.
Save to collectionCreate a collection in the sidebar first.
caution240 minadvanced13 stepsUbuntu Server

AI/ML · Software Engineering · DevOps & CI/CD · Security

Build a production chatbot with the OpenAI Responses API

Create a durable Node.js chatbot with OpenAI Conversations, typed response streaming, safe cancellation, transcript recovery, duplicate protection, explicit retention and deletion, real failure drills, and a production release gate.
Save to collectionCreate a collection in the sidebar first.
caution150 minadvanced10 stepsNode.js

AI/ML · Incident Response & Troubleshooting · Observability & Monitoring · Security

Build an incident-response assistant for alerts and logs

Build a production incident assistant that accepts signed alerts and bounded log excerpts, removes credentials and personal identifiers before durable storage, links every conclusion to immutable evidence, suggests only reviewed runbooks, drafts rather than performs external actions, requires an incident commander to approve dispatch, and exports a portable incident record.
Save to collectionCreate a collection in the sidebar first.
caution300 minadvanced13 stepsNode.js

AI/ML · Databases & Data · Services & Applications · Software Engineering

Build an e-commerce catalog assistant with safe recommendations

Build a production catalog assistant that imports merchant-approved structured product data, generates reproducible embeddings, combines semantic retrieval with exact price and category filters, treats stale inventory as unknown, keeps recommendation language inside explicit boundaries, and turns account or order help into a local handoff draft that a merchant operator must approve before a separate dispatcher writes to support.
Save to collectionCreate a collection in the sidebar first.
caution330 minadvanced15 stepsNode.js

Databases & Data · AI/ML · Security

Run production semantic search with PostgreSQL and pgvector

Pin PostgreSQL 18 and pgvector 0.8.5, enforce tenant RLS, store one validated vector dimension, ingest idempotently, measure HNSW and IVFFlat against exact recall, and prove maintenance, PITR, restore and rollback.
Save to collectionCreate a collection in the sidebar first.
caution420 minadvanced10 stepsPostgreSQL

AI/ML · Cloud & Infrastructure · Security · Observability & Monitoring

Deploy a production LiteLLM multi-provider gateway

Pin LiteLLM v1.93.0, publish stable provider aliases behind TLS and scoped virtual keys, enforce budgets and shared limits, constrain fallbacks by privacy policy, prove redaction, and rehearse recovery and rollback.
Save to collectionCreate a collection in the sidebar first.
caution480 minadvanced16 stepsLiteLLM Proxy

Services & Applications · Databases & Data · Security · Backup & Recovery

Deploy Nextcloud with PostgreSQL, Redis, TLS, Cron, backups, and verified restore

Deploy Nextcloud 34.0.2 on Ubuntu 24.04 with protected PostgreSQL and Redis, canonical Nginx TLS, observable Cron, complete backups, and an isolated application-level restore drill.
Save to collectionCreate a collection in the sidebar first.
danger360 minadvanced14 stepsNextcloud Server

Databases & Data · High Availability & Reliability

Configure PostgreSQL streaming replication and planned failover

Build and operate a PostgreSQL 18.4 hot standby with bounded WAL retention, verified lag, explicit fencing, planned promotion, endpoint cutover, and safe rewind or rebuild.
Save to collectionCreate a collection in the sidebar first.
danger360 minadvanced14 stepsPostgreSQL

Databases & Data · Observability & Monitoring

Find and fix slow PostgreSQL queries with pg_stat_statements and EXPLAIN

Deploy privacy-aware PostgreSQL 18.4 query statistics, identify normalized high-impact queries, capture safe estimated and actual plans, and validate one reversible fix.
Save to collectionCreate a collection in the sidebar first.
danger300 minadvanced14 stepsPostgreSQL

Databases & Data · Backup & Recovery

Recover PostgreSQL to a point in time with WAL archiving

Build a fail-closed PostgreSQL 18.4 WAL archive and verified base-backup chain, then restore to an exact target in isolation, validate while paused, promote, and re-establish protection.
Save to collectionCreate a collection in the sidebar first.
danger420 minadvanced17 stepsPostgreSQL

Databases & Data

Back up, restore, and test a PostgreSQL database

Produce a custom-format pg_dump, restore into isolation, compare invariants, and retain recovery evidence.
Save to collectionCreate a collection in the sidebar first.
caution40 minintermediate9 stepsPostgreSQL

Databases & Data · Security

Install and configure PostgreSQL on Ubuntu

Install PostgreSQL, create a least-privilege role and database, optionally enable restricted TLS network access, validate authentication order, and prove recovery readiness.
Save to collectionCreate a collection in the sidebar first.
caution45 minintermediate13 stepsUbuntu Server