RegSQL vs TSQLLint

RegSQL is a web SQL workspace combining browser-local formatting with optional AI assistance. Formatting runs in a browser worker without an account or server round trip. It adjusts whitespace and casing while preserving query logic, aliases, and comments, and accepts multi-statement input up to 1 MB. Listed dialects are PostgreSQL, MySQL, MariaDB, SQLite, BigQuery, SQL Server, Snowflake, and Oracle PL/SQL. AI tools can generate SQL from a description, explain an existing query, or suggest a repair. Formatting may reveal parsing problems, but RegSQL does not connect to a database or verify tables, columns, permissions, data types, or runtime behavior. SQL, prompts, and schema text are sent to the AI provider only after Generate, Explain, or Repair is chosen. The Free plan is free, billed Forever, with unlimited local formatting and 20 AI requests monthly. Indie costs $8 a month or $72 billed yearly ($6/month).

TSQLLint checks T-SQL scripts for anti-patterns and reports the findings. Its command-line tool can correct issues it identifies as auto-fixable with the --fix or -x option. Rules can be set to off, warning, or error; an error-level violation produces a non-zero exit code. Users can save settings in a .tsqllintrc file, or use the tool’s in-memory defaults when no file is present. The listed SQL Server compatibility levels are 80, 90, 100, 110, 120, 130, 140, and 150. Custom .NET plugins can extend it if they implement TSQLLint’s IPlugin interface and target net6.0. Before linting, it substitutes SQL file placeholders with values from environment variables. Official installation methods include dotnet-tool, Homebrew, and NPM. Its VS Code extension marks potential problems in opened .sql files for inspection on hover, and SQL Server Management Studio can invoke it through External Tools. TSQLLint is free under the MIT License and runs on Linux, macOS, and Windows, with an editor extension also listed.