Get Started with Confluence Databases
Confluence has always been a leading collaboration tool, but with its new database feature, teams can store and organize structured data all in one place. Whether you need to track project progress, assign work, or create a single source of truth for your documentation, Confluence databases are designed to streamline and elevate your team’s efficiency. This week, we’ll explore what makes these databases a must-have tool.
Why Use Confluence Databases?
Confluence databases allow teams to centralize data management while keeping it organized and accessible. Here are a few reasons why your team should start using them:
- Single Source of Truth: Create a reliable, unified place for information, minimizing confusion or data silos.
- Project Tracking: Monitor tasks and their progress while tracking responsible team members and deadlines.
- Customizable Layouts: Whether it’s table, card, or board views, databases allow you to customize how you display the data.
Let’s break down how you can create, configure, and manage databases to meet your team’s needs.
How to Create and Manage Confluence Databases
Creating a Database
Confluence offers multiple ways to create a database, ensuring that your workflows stay efficient. You can create a new database directly from the Create button, the space sidebar, or even from within a page editor.
If you're just starting, see the detailed guide on creating databases to understand how to build one quickly.
Editing Your Database Structure
Each database has fields where specific data can be entered and tracked. Need to add a new field or remove an old one? It’s as simple as clicking the "+" button or using the three-dot menu for field editing.
Pro Tip:
Don’t worry if you make a mistake—editing or deleting fields is quick, but keep in mind that deleting a field will also remove its associated data.
Adding and Displaying Entries
Once your database structure is set, you can start adding entries—either directly within the database or when it’s embedded on a Confluence page. You can also customize how data is displayed based on your team's needs.
- In-line Edits: Modify values directly in the table.
- Card/Board Layout: For more visual needs, you can switch to card or board views, especially helpful when managing tasks.
Large databases are powerful, but keep in mind that as your data grows, it may take more time to load.
Displaying and Managing Your Database
Confluence databases allow teams to filter, sort, and display data where it’s needed most. Want to embed a database into a page? Simply use Smart Links to bring relevant data into any Confluence page or blog post.
Tip:
You can customize how your database is viewed, ensuring the data you need is at your fingertips. See the Database views guide for more details.
Upcoming Features: JQL and Calculations
One of the most exciting updates to Confluence databases is the ability to use JQL (Jira Query Language) to pull real-time Jira data into your database fields. This feature enables your team to leverage Jira issues, statuses, and more, directly within Confluence databases, keeping all your project data linked and up-to-date.
Even more powerful—calculation features are on the way! Soon, you’ll be able to run calculations directly in your database, whether you need to summarize project costs or calculate task progress percentages. No need to switch between apps for data analysis!
Managing Database Permissions and Sharing
Databases in Confluence can be shared, moved, or restricted just like any other Confluence content. This flexibility ensures your sensitive data stays protected while remaining accessible to the right team members.
Note:
Permissions are managed at the space level, and you can always adjust who can view or edit your database. See Content restrictions for more on managing access.
Conclusion
Confluence databases are a game-changer for teams looking to centralize their data management while keeping things simple. With features like JQL integration, customizable views, and upcoming calculation capabilities, Confluence databases will help your team stay organized and efficient.
Ready to give them a try?
Start creating your first database today and unlock the potential of structured data management in Confluence!