Azimutt

Azimutt is a comprehensive database exploration and analysis platform specifically engineered to handle large and complex database systems. It serves a wide range of professionals, including Developers, Architects, DBAs, Data Analysts, and Product Managers, by providing the tools necessary to navigate, understand, and document intricate database schemas. Whether you're dealing with a large monolith or numerous microservices, Azimutt offers a seamless and intuitive experience to keep your database operations performant and your team aligned.

How to use Azimutt

Getting started with Azimutt is straightforward and designed to be frictionless:

1. Connect Your Database: Begin by connecting to your database. You can use a direct database connection URL, upload a SQL schema file, or start with one of the provided sample projects. No signup is required for initial exploration.
2. Explore Incrementally: Use the Explorer to build visual layouts of your schema piece by piece. Instead of being overwhelmed by the entire schema, you can search for specific tables, follow their relationships, and find paths between different entities to focus only on what's relevant to your task.
3. Investigate with AI: Leverage the Digger for rapid data investigation. Use its AI capabilities to automatically generate complex SQL queries from plain English prompts, or explore data across multiple connected databases from a single interface.
4. Document and Collaborate: Use the Archivist to create living documentation. Add contextual notes to tables and columns, create floating markdown memos on your layouts to explain complex logic, and use tags to organize your schema. This turns your diagrams into a shared source of truth for the team.
5. Analyze and Optimize: Employ the Doctor to proactively monitor your database's health. It runs dozens of checks against your schema and runtime to identify common mistakes, design flaws, and performance bottlenecks, providing actionable suggestions for improvement.
6. Design with Code: For those who prefer a code-first approach, Azimutt offers the Azimutt Markup Language (AML), a minimal DSL that allows you to design and script beautiful, accurate diagrams at typing speed.

Core Features of Azimutt

• Seamless Schema Exploration: Incrementally build diagrams, search everything, follow relations, and find the shortest path between tables to untangle complex schemas.
• AI-Powered Assistance: Generate, explain, fix, and optimize SQL queries using AI. This feature accelerates debugging and data retrieval tasks.
• Collaborative Documentation: Enhance your schema with contextual notes on tables/columns, floating markdown memos on layouts, and organizational tags.
• Database Analysis & Optimization (The Doctor): Automatically checks for dozens of common schema and runtime mistakes to maintain database health and performance.
• Diagram as Code (AML): Use the Azimutt Markup Language (AML) to design and describe your database schema with a minimal, text-based DSL.
• Broad Database Support: Natively connects to PostgreSQL, MySQL, SQL Server, MongoDB, Snowflake, BigQuery, and many others. It also supports any SQL schema file.
• Privacy-Focused Architecture: The tool is open-source, performs all parsing in the browser, allows local project saving, and offers a self-hosting option to ensure your data remains private and secure.

Use Cases for Azimutt

Azimutt is a versatile tool that addresses numerous challenges:

• Onboarding New Developers: New team members can quickly understand a complex database schema, reducing ramp-up time.
• Data Analysis & Reporting: Data analysts can explore new data sources, understand relationships, and generate queries without extensive prior knowledge.
• Bug Investigation: Developers and support teams can rapidly trace data relationships to find the root cause of bugs and incidents.
• Database Migration & Refactoring: Architects and DBAs can visualize the current state, plan structural changes, and document the target design effectively.
• Improving Engineering Efficiency: Tech leads can create a central, living documentation of their database, fostering better collaboration and knowledge sharing across the organization.

Advantages of Azimutt

Azimutt stands out from other database tools with several key advantages:

• Built for Complexity: It excels where other tools struggle, specifically with large, monolithic databases or complex microservice architectures.
• Incremental Exploration: Avoids information overload by allowing you to build your view piece by piece, focusing only on the relevant parts of the schema.
• All-in-One Platform: It uniquely combines schema exploration, data exploration, documentation, design, and analysis in a single, cohesive tool.
• Developer-Centric: Offers a CLI, a VS Code extension, and a "Diagram as Code" approach with AML, catering to modern development workflows.
• Enhanced Collaboration: Shared layouts, notes, and memos transform static diagrams into dynamic, living documentation that benefits the entire team.

Pricing and Plans

Azimutt offers a flexible pricing structure to suit different needs:

• Free: Ideal for quick, temporary exploration. Includes unlimited tables, schema exploration, and data exploration. No long-term project saves.
• Solo (€7/month, billed annually): Designed for individual professionals. Includes all Free features plus long-term project saves (up to 3 projects), database design capabilities, and schema export.
• Team (€35/user/month, billed annually): Perfect for collaborative teams. Includes all Solo features plus database analysis, advanced collaboration tools, AI capabilities, and project export.
• Enterprise (Custom Pricing): Tailored for large organizations requiring advanced security and control. Includes all Team features plus unlimited usage, user management (SSO), API access, on-premise support, and dedicated consulting.