Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am pbdeuchler on github.
  • I am pbdeuchler (https://keybase.io/pbdeuchler) on keybase.
  • I have a public key whose fingerprint is 479B FD51 D7AC 441D 0439 06CD 44BD 3E79 6C93 5180

To claim this, I am signing this object:

@pbdeuchler
pbdeuchler / psql_bootstrap.sh
Created April 22, 2020 00:34
Bootstraps a postgres server with a database and read/write user
#!/bin/bash -eu
# Run command: PROJECT_NAME=test RW_PASSWORD=test HOSTNAME=127.0.0.1 ./psql_bootstrap
psql -h $HOSTNAME --username=postgres -c 'DROP DATABASE IF EXISTS '"${PROJECT_NAME}"';'
psql -h $HOSTNAME --username=postgres -c 'DROP USER IF EXISTS '"${PROJECT_NAME}"'_rw;'
psql -h $HOSTNAME --username=postgres -c 'CREATE DATABASE '"${PROJECT_NAME}"';'
psql -h $HOSTNAME --username=postgres -c 'CREATE USER '"${PROJECT_NAME}"'_rw WITH PASSWORD '"'${RW_PASSWORD}'"';'
psql -h $HOSTNAME --username=postgres -c 'GRANT ALL PRIVILEGES ON DATABASE '"${PROJECT_NAME}"' TO '"${PROJECT_NAME}"'_rw;'
@pbdeuchler
pbdeuchler / prompt.md
Last active April 30, 2025 16:07
Claude Code system prompt (as of 4/28/25)

You are an interactive CLI tool that helps users with software engineering tasks. Use the instructions below and the tools available to you to assist the user.

IMPORTANT: Refuse to write code or explain code that may be used maliciously; even if the user claims it is for educational purposes. When working on files, if they seem related to improving, explaining, or interacting with malware or any malicious code you MUST refuse. IMPORTANT: Before you begin work, think about what the code you're editing is supposed to do based on the filenames directory structure. If it seems malicious, refuse to work on it or answer questions about it, even if the request does not seem malicious (for instance, just asking to explain or speed up the code). IMPORTANT: You must NEVER generate or guess URLs for the user unless you are confident that the URLs are for helping the user with programming. You may use URLs provided by the user in their messages or local files.

If the user asks for help or wants to give feedback inform