Support
To check known issues (or if you want to file one), view this app's issue tracker.
To learn more about the app, you should:
- Read the documentation.
- Look around the forums.
This is a supported app, so you may contact the vendor (or support contact) for help:
Description
Connect databases with a simple, form-based setup
Spend less time configuring your data and more time gaining valuable insights. Create and save up to 3 data source profiles with step-by-step configuration. Monitor connection status with real-time, visual indicators.
Run and modify SQL queries in an intuitive editor
Preview your SQL queries live and customize the results in an easy, form-based macro editor.
Display SQL data as a table, chart, or graph
Display business intelligence reports as dynamic tables with advanced sorting, filtering, totaling, & styling. Combine with Confluence's Chart macro to visualize SQL data as charts or graphs.
*Formerly a Bob Swift app.
More details
For unlimited database connections, a Data Center approved version, and additional features, see SQL for Confluence (Pro Edition).
Highlights:
- Preview your SQL queries live and customize the results in an intuitive editor
- Use with Confluence's native Chart macro to visualize your SQL query results
- Enhance your data tables with column sorting, filtering, totaling, row highlighting, and other custom styling
- Access your MSSQL, Oracle, PostgreSQL, and MySQL databases
- Combine multiple data sources for richer reports
- Use with Macro Security for Confluence, Run Self-Service Reports for Confluence, and Cache for Confluence to create the ultimate BI dashboard
The Appfire platform features dozens of top-selling apps that help teams worldwide solve big challenges.
Version history
11.0.1Confluence Server 7.4.17 - 8.2.32023-02-27Addressed minor issues No release notes.11.0.0Confluence Server 7.4.17 - 8.1.42023-02-23Compatibility with Confluence 8.x - https://appfire.atlassian.net/wiki/spaces/SQL/pages/200901300/Release+notes+-+11.0.0
10.4.6Confluence Server 7.0.1 - 7.20.32022-08-30Rebranding changes No release notes.10.4.5Confluence Server 6.13.0 - 7.19.102022-04-12Minor improvements and security fixes Security fixes and CCMA library changed from tracker to listener
10.4.4Confluence Server 6.13.0 - 7.17.52022-01-12Enhancements and Bug fixes No release notes.10.4.2Confluence Server 6.13.0 - 7.15.32021-08-31Addressed minor defects Addressed minor defects
10.4.0Confluence Server 6.13.0 - 7.13.182021-05-04Addressed minor defects identified internally Addressed minor defects identified internally
10.3.1Confluence Server 6.13.0 - 7.12.52021-02-16Addressed bugs identified internally and reported by users Addressed bugs identified internally and reported by users
10.3.0Confluence Server 6.13.0 - 7.11.22021-01-05Apply column filters to tables in Confluence Apply column filters to tables in Confluence
10.2.0Confluence Server 6.11.0 - 7.10.22020-06-17Filter table data, define delimiter for exports, improved row and column styles. In version 10.2:
- Use search terms or regular expressions to filter table data
- Specify a custom file delimiter such as comma, tab, or semicolon to be used when table data is downloaded or exported
- Enforce user-defined CSS styles for rows and columns
Read more in the full release notes.
10.1.1Confluence Server 6.11.0 - 7.5.22020-02-17Content on the page is inconsistent & data source profiles 1. Content on the page is inconsistent due to conflict in css classes
2. Unable to fetch data source profiles for the macro users
10.1.0Confluence Server 6.5.0 - 7.5.22019-10-30Fix to create the SQL Server profile using a simple (recommended) setup type. No release notes.10.0.1Confluence Server 6.5.0 - 7.1.22019-09-13SQL for Confluence (Express Edition) is now compatible with Confluence 7.0 SQL for Confluence (Express Edition) is now compatible with Confluence 7.0
10.0.0Confluence Server 6.0.1 - 6.15.102019-06-24Customize SQL data tables with ease using a new, more intuitive macro editor What’s new in v10.0?
- Run and format queries in a redesigned, form-based macro editor
- Apply advanced styling and formatting to your tables more easily
- Fine-tune your data tables faster with a collapsible preview tray
- Locate your saved, external SQL scripts in an improved menu
Read more in the full release notes.
9.2.0Confluence Server 6.0.1 - 6.15.102019-03-21This release includes several bug fixes. 9.1.0Confluence Server 6.0.1 - 6.15.102018-09-17Support for Data Center read-only mode and minor fixes This release includes some minor fixes.
For more information, read the full release notes.
Our server apps have always been Data Center compatible, and with the release of Atlassian’s new Data Center approved apps program, we've made massive investments in additional infrastructure and testing frameworks for our Data Center apps to ensure that they will scale to meet the needs of enterprise teams. These apps have been rigorously tested and vetted for consistent, efficient, and reliable performance at scale.
There is currently no Data Center approved version of SQL for Confluence Express Edition. If you’re using Confluence Data Center or thinking about upgrading, check out the Data Center approved version of SQL for Confluence Pro Edition.
9.0.1Confluence Server 6.0.1 - 6.11.22018-07-11Fixes What's new in version 9?
Configure your data sources with ease — We've completely redesigned the admin configuration page to make it easier to connect to your SQL databases. Say goodbye to messy strings and hello to a straightforward, form-based setup.
Monitor data source connections in real time — Ensure your data sources are set up correctly from the start and stay connected with enhanced editing and visual connectivity indicators.
Read more in the full release notes.
9.0.0Confluence Server 6.0.1 - 6.10.32018-06-07Configure data sources with ease and monitor connections in real time. What's new in version 9?
Configure your data sources with ease — We've completely redesigned the admin configuration page to make it easier to connect to your SQL databases. Say goodbye to messy strings and hello to a straightforward, form-based setup.
Monitor data source connections in real time — Ensure your data sources are set up correctly from the start and stay connected with enhanced editing and visual connectivity indicators.
Read more in the full release notes.
8.5.0Confluence Server 5.10.0 - 6.9.32017-12-06Added avgIgnoreZero column calculation and other fixes. 8.4.0Confluence Server 5.8.2 - 6.5.32017-05-30Improved sticky table headers support and fixes 8.3.0Confluence Server 5.7 - 6.2.42016-11-23Allow export table view as CSV, library updates, fixes 8.2.0Confluence Server 5.7 - 6.0.72016-10-03Confluence 6.0, updated libraries, fixes 8.1.0Confluence Server 5.5 - 5.10.92016-05-12Fixes 8.0.1Confluence Server 5.5 - 5.9.142015-10-27Confluence 5.9 support, remove RB dependencies, fixes 8.0.0Confluence Server 5.7 - 5.8.182015-10-21Confluence 5.9, remove RB dependencies, fixes Release Notes 8.0 (important!)
7.1.1Confluence Server 5.4.3 - 5.8.182015-03-07Fix to show data source profiles in drop-down list for non-administrators 7.1.0Confluence Server 5.4.3 - 5.7.42015-02-10Get started dialog, updated libraries 7.0.2Confluence Server 5.2 - 5.7.42015-03-08Fix to show data source profiles in drop-down list for non-administrators 7.0.1Confluence Server 5.2 - 5.7.42015-01-18Get started fix and improvement. Correct example configuration 7.0.0Confluence Server 5.2 - 5.6.62014-11-25Initial release of Express Edition