5
650
Customers have installed this app in at least 650 active instances.

    Play SQL Base

    by Play SQLfor Confluence Server 7.0.1 - 7.10.1 and more versions
    Versions available for Confluence Server 5.0 - 6.15.10
    Unsupported
    This app isn't formally supported.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Supported
    Play SQL supports this app.

    Get support

    Unsupported
    This app isn't formally supported.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Get it nowFree app

    An awesome SQL client for Confluence... if you have PostgreSQL

    An awesome SQL client for Confluence... if you have PostgreSQL

    An awesome SQL client for Confluence... if you have PostgreSQL

    Sexy SQL editor

    Format your results

    As Wysiwyg as SQL can be

    We'll get you started writing SQL thanks to syntax coloring, contextual help and SQL wizards. Buff your query, then ship the macro on several pages.

    Display numbers as a currency amount "$ 123,00". Resize columns. Use icons, totals. Timeouts. Cache. It's a full-featured solution.

    Alright, SQL isn't easy to master, but we've made our best to integrate it beautifully in Confluence.

    More details

    This free add-on lets you query databases (mostly HSQL and PostgreSQL). It is also the basis for the (paid) Play SQL Spreadsheets add-on with read-write features.

    • Sexy Query Editor: SQL coloring, column list on the right, wizards.
    • Totals,
    • Cache,
    • Timeout,
    • User Parameters (reuse a user entry in your query),

    Output modes: Rich, Confluence table, Text, Print. The Rich mode has:

    • Asynchronous,
    • Flush the cache,
    • Sorting, pagination and filtering by clicking on the headers (To come in the next release).

    Technical details:

    • Database monitor to kill long-standing queries (available for PostgreSQL 9.2+ only),
    • One datasource per space and visibility permissions based on the space,
    • Databases:
      • Postgres (officially supported) 9.2 is required for database monitoring, 9.0 is the minimum,
      • Oracle (non-supported, works with limited features),
      • MySQL (non-supported, works with limited features)

    Reviews for cloud

    (5)
    Sign in to write a review
    by SorinC on 2015-05-15
    This is a great plugin and we really appreciate that Adrien made it free. The only thing that we really miss is the ability to query multiple databases across multiple spaces. The current implementation that requires you to connect each space to a single database doesn't work for us. We need a list of databases that can be used in any page. UPDATE: Usually I do not get 4/4 stars on my reviews but this vendor proved to be able to provide very good and quick response and I would give it 5/4 stars if it would be possible.
    2 out of 2 found this review helpful
    Was this review helpful?YesNo
    by Fabio Racobaldo [Herzum] on 2014-11-26
    Very useful plugin and great support!
    2 out of 2 found this review helpful
    Was this review helpful?YesNo
    Play SQL
    See that's why I love customers ;)
    by Ethan Foulkes on 2014-04-11
    This is one of the most powerful free plugins on the Marketplace! I usually avoid free plugins unless they are written by solid proven plugin vendors. Adrien may be new to plugins but having worked at Atlassian he knows the products and actually provides the best support of any plugin vendor I've encountered...even on the free version!!!
    1 out of 1 found this review helpful
    Was this review helpful?YesNo

    Reviews for server

    (5)
    Sign in to write a review
    I like it! Not 4* because some issues: - not working SQL - had to copy paste into a new table then works OK - cannot connect to more than one database per space - charts work only with logged-in users (but tables show OK) - #rows to display per page not customizable
    Was this review helpful?YesNo
    by Arif Suprabowo on 2018-08-12
    I just install this plugin and try to modify default row in table pagination from 50, is it possible ?
    0 out of 1 found this review helpful
    Was this review helpful?YesNo
    by SorinC on 2015-05-15
    This is a great plugin and we really appreciate that Adrien made it free. The only thing that we really miss is the ability to query multiple databases across multiple spaces. The current implementation that requires you to connect each space to a single database doesn't work for us. We need a list of databases that can be used in any page. UPDATE: Usually I do not get 4/4 stars on my reviews but this vendor proved to be able to provide very good and quick response and I would give it 5/4 stars if it would be possible.
    2 out of 2 found this review helpful
    Was this review helpful?YesNo
    by Fabio Racobaldo [Herzum] on 2014-11-26
    Very useful plugin and great support!
    2 out of 2 found this review helpful
    Was this review helpful?YesNo
    Play SQL
    See that's why I love customers ;)
    by Ethan Foulkes on 2014-04-11
    This is one of the most powerful free plugins on the Marketplace! I usually avoid free plugins unless they are written by solid proven plugin vendors. Adrien may be new to plugins but having worked at Atlassian he knows the products and actually provides the best support of any plugin vendor I've encountered...even on the free version!!!
    1 out of 1 found this review helpful
    Was this review helpful?YesNo

    Reviews for Data Center

    (5)
    Sign in to write a review
    by SorinC on 2015-05-15
    This is a great plugin and we really appreciate that Adrien made it free. The only thing that we really miss is the ability to query multiple databases across multiple spaces. The current implementation that requires you to connect each space to a single database doesn't work for us. We need a list of databases that can be used in any page. UPDATE: Usually I do not get 4/4 stars on my reviews but this vendor proved to be able to provide very good and quick response and I would give it 5/4 stars if it would be possible.
    2 out of 2 found this review helpful
    Was this review helpful?YesNo
    by Fabio Racobaldo [Herzum] on 2014-11-26
    Very useful plugin and great support!
    2 out of 2 found this review helpful
    Was this review helpful?YesNo
    Play SQL
    See that's why I love customers ;)
    by Ethan Foulkes on 2014-04-11
    This is one of the most powerful free plugins on the Marketplace! I usually avoid free plugins unless they are written by solid proven plugin vendors. Adrien may be new to plugins but having worked at Atlassian he knows the products and actually provides the best support of any plugin vendor I've encountered...even on the free version!!!
    1 out of 1 found this review helpful
    Was this review helpful?YesNo

    Cloud Pricing

    Server Pricing

    Data Center Pricing

    Play SQL provides support for this app.

    Vendor support resources

    Documentation

    Find out how this app works.

    See existing Q&A in Atlassian CommunityAsk a question in the Atlassian Community

    Atlassian-hosted discussions connect you to other customers who use this app.

    Versions

    Version 3.2.1 • Confluence Server 7.0.1 - 7.10.1 • Released 2020-09-30

    Summary

    Maintenance release

    Details

    Re-publication of 3.2.0 with only the bugfixes and compatibility with Confluence 7.8.0.

    • PLAYSQL-286 Export foreign key *values* to Excel along with the foreign key ID.
    • PLAYSQL-276 Display 200 records by default, and keep the pagination widget visible when scrolling horizontally, so users don't believe it is the end of the table.

    Installation

    1. Log into your Confluence instance as an admin.
    2. Click the admin dropdown and choose Add-ons. The Manage add-ons screen loads.
    3. Click Find new apps or Find new add-ons from the left-hand side of the page.
    4. Locate Play SQL Base via search. Results include app versions compatible with your Confluence instance.
    5. Click Install to download and install your app.
    6. You're all set! Click Close in the Installed and ready to go dialog.

    To find older Play SQL Base versions compatible with your instance, you can look through our version history page.

    Similar apps