SQLFluff Integration Now Available in PopSQL!

November 9th, 2023

We're thrilled to announce that PopSQL has partnered with SQLFluff to bring real-time SQL linting to your query editor! This new feature is designed to streamline your workflow, enhance code quality, and enforce consistent SQL coding practices within your team.

Watch a brief demo of SQLFluff in PopSQL or keep reading for more information.

Real-time Linting

As you type your SQL queries in PopSQL, SQLFluff will now lint your code in real-time. This means immediate feedback on your SQL syntax, style, and any potential errors, saving you time and hassle with instant visibility into areas of improvement.

Enable in Organization Preferences

This powerful new feature can be easily enabled within your organization's preferences in PopSQL. Here's how:

  1. Go to your preferences.

  2. Navigate to the 'Linter' section.

  3. Toggle on the integration for SQLFluff linting and add your configuration rules.

Custom SQLFluff Configuration

PopSQL understands that different teams have different coding standards. That's why we've made it possible for you to add your own SQLFluff configuration file. Customize linting rules to align with your team's conventions and maintain the integrity of your codebase. Here's how to customize:

  1. Create a .sqlfluff configuration file with your desired rules.

  2. Paste it into the SQLFluff configuration box in your Linter settings in PopSQL.

  3. SQLFluff will use your custom rules to lint queries.

Benefits of SQLFluff Integration:

  • Consistency: Maintain a consistent code style across your entire team's SQL scripts.

  • Quality Assurance: Catch potential errors early in the development process.

  • Efficiency: Reduce the need for manual code reviews for stylistic or simple logical errors.

Get Started

To get started, update your PopSQL to the latest version and explore the organization preferences to enable SQLFluff linting. Should you need any assistance or have feedback, check out the SQL Linting documentation, or reach out to our support team!

Feedback

We're excited to see how this integration will help improve your team's productivity and code quality. If you have any feedback or suggestions, please reach out to us!

Happy querying,

The PopSQL Team

Ready for a modern SQL editor?