db_ai.bash

#!/usr/bin/env bash
# mise description="Generate the DB schema for the AI Contexts"
set -euo pipefail

cd "$(git rev-parse --show-toplevel)"

mkdir -p ./AIContexts/

docker run --rm -v "$PWD/AIContexts:/data" postgres:15 \
  pg_dump $POSTGRES_URL -s -O -x -n public -t public.* -f /data/db_schema.sql


echo "Please follow up by asking ai (Cursor Long Context Chat) to create compressed version of the db schema
Rewrite this DB schema for AI context:
- Shorten it by incorporating foreign keys, indexes, primary keys, and unique constraints directly into CREATE TABLE statements.
- Remove views, `SET` statements, and `create policy` statements.
"