llm-sql-prompt 0.2.0

Utility to generate ChatGPT prompts for SQL writing, offering table structure snapshots and sample row data from Postgres and sqlite databases.

ChatGPT Prompt for SQL Writing

Generate a prompt for writing SQL queries with LLMs like ChatGPT. Drop your database URL and table name into the script and it will generate a prompt for you to copy and paste into your favorite LLM.

What this does

• Snapshot of Table Structure: Understand the columns, types, and organization of your table at a glance.
• Sample Rows: Includes INSERT statements to describe the data in your table.

Usage

Usage: llm-sql-prompt [OPTIONS] DATABASE_URL [TABLE_NAME]

Options:
  --help  Show this message and exit.

Generate a prompt from a postgres database:

llm-sql-prompt postgresql://postgres:postgres@localhost:5555/database_name table_name | pbcopy
llm-sql-prompt $DATABASE_URL

TODO

Super basic script, needs a lot of work

• pg support
• one entrypoint
• multiple tables
• prompt tweaking
• understand prompt size limits and sample records until one fits