philiprehberger-sql-print

Pretty-print and format SQL queries for debugging.

Installation

pip install philiprehberger-sql-print

Usage

Format SQL

from philiprehberger_sql_print import format_sql

query = "SELECT id, name FROM users WHERE active = 1 AND role = 'admin' ORDER BY name"
print(format_sql(query))

Output:

SELECT id, name
FROM users
WHERE active = 1
  AND role = 'admin'
ORDER BY name

Print SQL with syntax highlighting

from philiprehberger_sql_print import print_sql

print_sql("SELECT * FROM orders LEFT JOIN users ON orders.user_id = users.id WHERE total > 100")

Prints formatted SQL with ANSI color-coded keywords, strings, and numbers.

Disable colors or uppercase

from philiprehberger_sql_print import print_sql

# No ANSI colors (useful for logging)
print_sql("select id from users", color=False)

# Preserve original keyword casing
print_sql("select id from users", uppercase=False)

Custom indentation

from philiprehberger_sql_print import format_sql

print(format_sql("SELECT id FROM users WHERE active = 1", indent=4))

API

Parameters

Development

pip install -e .
python -m pytest tests/ -v

Support

If you find this project useful:

⭐ Star the repo

🐛 Report issues

💡 Suggest features

❤️ Sponsor development

🌐 All Open Source Projects

💻 GitHub Profile

🔗 LinkedIn Profile

License

MIT