{"id":14354,"date":"2023-05-04T09:28:17","date_gmt":"2023-05-04T16:28:17","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=14354"},"modified":"2025-06-13T18:33:07","modified_gmt":"2025-06-14T01:33:07","slug":"explore-your-couchbase-buckets-with-azimutt","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/explore-your-couchbase-buckets-with-azimutt\/","title":{"rendered":"Explore your Couchbase Buckets with Azimutt"},"content":{"rendered":"

Azimutt <\/a>is a Next-Gen ERD that allows you to Design, Explore, Document and Analyze your database. What is an ERD, you ask? ERD stands for Entity Relationship Diagram<\/strong>. Because, yes, you can have (virtual) entity relationships in a document database. A picture being better than a thousand words, here\u2019s the kind of result you can achieve by connecting a database to Azimutt.<\/p>\n

\"\"
\nSo how does it work with Couchbase? Right now, you cannot directly connect your cluster to it, you need to export an Azimutt schema from your cluster, but it\u2019s pretty straightforward.<\/p>\n

You need your username<\/em>, password<\/em> ,\u00a0connection URL<\/em> and a command line terminal. If you don\u2019t have an instance on hand, you can quickly get one up and running with our free trial on cloud.couchbase.com<\/a>. While writing this post I created a new user who only has access to the travel-sample <\/em>bucket that should be automatically imported when creating a new trial.<\/p>\n

In your terminal, run:<\/p>\n

npx azimutt export couchbase \"couchbases:\/\/userName:P4ssword@cb.zw-scs3n3uw-t7ww.cloud.couchbase.com\" --output travel-sample.json<\/pre>\n
This command browses all your buckets, scope and collections, gets some document samples from them, and creates an inferred schema from these documents. You can specify exactly which bucket to export with the \u2013bucket parameter. Take a look at the complete list on the associated npm page<\/a>.<\/p>\n
The output produces a JSON file containing something like:<\/p>\n
\"tables\": [\r\n  {\r\n\u00a0\u00a0 \"schema\": \"travel-sample\",\r\n\u00a0\u00a0 \"table\": \"inventory__airline\",\r\n\u00a0\u00a0 \"columns\": [\r\n\u00a0\u00a0\u00a0\u00a0 {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \"name\": \"callsign\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \"type\": \"string\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \"nullable\": true\r\n\u00a0\u00a0\u00a0\u00a0 },\r\n\u00a0\u00a0\u00a0\u00a0 {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \"name\": \"country\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \"type\": \"string\"\r\n\u00a0\u00a0\u00a0\u00a0 },\r\n\u00a0\u00a0\u00a0\u00a0 {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \"name\": \"iata\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \"type\": \"string\",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \"nullable\": true\r\n\u00a0\u00a0\u00a0\u00a0 },\r\n\u2026<\/pre>\n
The export might encounter issues if you don\u2019t have a primary index on every namespace being imported. For instance, there\u2019s no primary index for the tenant_0X<\/em> scopes of the travel-sample<\/em>, but we can ignore that.<\/p>\n
From there, you are ready to go to azimutt.app<\/a> and create your account (and take a look at the full list of features while you are there). This is what I see when logging in with my GitHub account:<\/p>\n
\"\"
\nFrom there you can create a new project. As we saw earlier, there is currently no way to directly connect your database, which is fine. Instead, click on From JSON<\/em> and upload your travel-sample.json<\/em> file generated earlier.<\/p>\n
\"\"<\/p>\n
You are now ready to explore your different entity diagrams, document them, add memos, and share them with your colleagues.<\/p>\n
\"\"<\/p>\n
I have added the relations myself. So granted, this is more ED than ERD, but you still get a visual overview of your bucket content and the ability to document your data and relationships between entities, even if you cannot enforce them on the schema level like you would with a traditional RDBMS.<\/p>\n
There is also support for nested structures, like the reviews.rating<\/em> field in this screenshot:<\/p>\n
\"\"<\/p>\n
If you like what you see and want to support this project, you can vote for them on Product Hunt<\/a>. They are happy to receive contributions and if you are looking to extend the Couchbase support, there are some interesting tasks available:<\/a><\/p>\n