If you're looking for a tool that offers database linting and optimization recommendations, Azimutt is a great option. It's a full-featured database explorer and analyzer with an interactive command-line interface. Azimutt has features like a scalable ERD, AML design, documentation and presentation, linting, path finding between tables, and collaboration tools. It supports relational and document-based databases, and there's a free tier with limited features, with customization and performance analysis in the Enterprise tier.
Another tool that can be helpful is TEXT2SQL, an AI-powered SQL query builder that can convert plain English into SQL queries. It supports multiple SQL dialects and can generate SQL queries from English prompts, explain SQL queries, correct errors, and work with custom database schemas. TEXT2SQL also generates Excel formulas and Regex expressions, so it's good for learning SQL skills and automating professional work. There's a free trial and a variety of pricing plans for different needs.
If you're using Metabase and need help with SQL queries, Avanty is a helpful Chrome extension. Avanty uses AI to help you write, edit and understand SQL queries, with features like generating queries from natural language prompts, editing SQL, suggesting chart title wording, debugging errors and formatting queries. It works with self-hosted and Metabase Cloud installations and offers email and Slack support, so it's a good option for data analysts who want to improve their workflow.