SQL Formatter for Stored Procedures

Your data never leaves your browser

Format to separate SQL from procedural logic.

Example

CREATE OR REPLACE PROCEDURE update_stats(p_user_id INT) LANGUAGE SQL AS $$ UPDATE stats SET count = (SELECT COUNT(*) FROM logs WHERE user_id = p_user_id) WHERE user_id = p_user_id; $$;

Tips

  1. 1Format SQL inside separately.
  2. 2Indent parameters.
  3. 3Separate declarations from queries.

Frequently Asked Questions

Procedural logic?

SQL formats. IF/LOOP: basic.

Triggers?

Yes.

All databases?

Select dialect.