Dashboard Builder Logo

The ultimate open source dashboard tool for professional dashboards


Open Source Dashboard overview:

Open source dashboard is the most comprehensive competitive drag-drop tool for the dashboard in which source code is released under a license and the users are granted the rights to use, change, and distribute the opensource dashboard to anyone and for any purpose. This Open Source tool is written in the most widely used Open Source platform such as PHP, Apache, MySQL, HTML5 and JavaScript.

What is an Open Source Dashboard?

Open-source dashboard is a type of data visualization tool in which source code is released under a license in which users are granted the rights to study, read and modify changes, and distribute the tool to anyone and for any purpose. Unlike traditional data visualization software distributed in an unchangeable compiled format, Our enterprize edition of open-source dashboard is delivered with both full source code and non-compiled formats, allowing open code modification.

Create interactive dashboards with the best open source dashboard tool

This SQL dashboard open source empowers the non-technical user with the ability to connect the database using PDO, the most common and widely used database connection to fetch data from an open-source platform such as MySQL, MS SQL, SQLite, ORACLE, PostgreSQL, Sybase and Cubrid, CSV and MS EXCEL files, and create interactive dynamic dashboards and business intelligence reports. Our open source dashboard software for excel also retrieve data from excel, CSV, and Google sheet to display graph, table, charts, and dashboard in all major environment supports PHP frameworks. This open-source dashboard provides a variety of chats like line chart, scatter chart, bar chart, pie chart, donuts chart, bubble chart, stack chat, area chart, heatmap chart, Sankey diagrams, and choropleth map. The user can download these dynamic charts in the PNG image format. This open-source dashboard enables to customize dashboard layout with the most powerful drag-and-drop features to place each chart exactly where you want for optimal representation. This drag-and-drop layout is fully responsive and compatible with PC, mobile phone, and tablets using the most powerful front-end open source dashboard framework such as D3.js and Bootstrap framework.

People always come up with the question of what is the best open source dashboard frameworks and where can we get this one. Well, the answer is open source dashboard is using the best open source dashboard frameworks. Our open-source dashboard for visualizing data tools is based on D3.js which is the most widely used JavaScript library for producing dynamic and interactive data visualizations in web browsers. Our dashboard uses the widely implemented SVG, HTML5, and CSS standards which can be created either static or real-time data coming from a variety of data sources.

Getting Started

In our dashboard PHP MySQL open-source example, we will be fetching data from MySQL open source database and build a simple dashboard and then will generate PHP source code for our web application. For this, we will be demonstrating with our freely available open-source drag and drop based open source web dashboards. To install and run the open-source dashboard php, following are the requirements.



This open source dashboard can be installed any platforms like Windows, Linux and Ubuntu or any other platforms support Apache, Nginx etc.

  • PHP Version 5.6 or later
  • Apache 2 or later
  • Windows 7 or later /Linux 3 or later
  • Firefox 52, Chrome 57, IE 8



There is a Free version of the Open Source Dashboard available for trail bases


Open Source Dashboard examples

Before really going into connecting the database and fetching the data with this web dashboard open source software, make sure that your Web Server (like Apache, Nginx, etc) is configured to display documents in the folder which will contain dashboard. Read-Write permission to the folders and sub-folders of dashboardbuilder i.e chmod -R 777 dashbboardbuilder-v3-FREE. Check your browser inspector/console to make sure that there isn't any error being reported, and all the Open Source Dashboard builder files are being loaded properly.

How to create your first dashboard with open source dasbhaord tool

In this section, we will walk you through with the step by step on how to create your first inertactive open source dahsobard with this great open source tool.



Welcome Screen


This is the main panel of the Open Source Dashboard an HTML5 based fully responsive interface built in PHP, HTML, JavaScript and CSS. The interface has a minimal design with a drag-and-drop feature that allows you to add multiple chart panel to customize the dashboard on according to the way you want.

  • Following screen will appear. Select Database from data source tab. Select SQLite from the drop down list of Database, Enter your "../data/Northwind.db" in the DB name field and Save changes    as mentioned in the screen.


Select your Database



  • A green tick mark with Database  will appear when your database is successfully connected.


Dashboard Preference


  • Select the gear icon for your Dashboard MySQL open source preference.


Database Connected


  • The following screen will appear. List of the tables will appear.


Chart Preference


  • Enter your SQL statement in text box, SQL field as the following manner

SELECT strftime('%Y-%m',o.shippeddate) as xaxis, sum(d.quantity) as yaxis from `order details` d, orders o where o.orderid = d.orderid group by strftime('%Y-%m',o.orderdate) limit 50

  • Click the Run Query button

SQL Statement


  • Query Result will appear. Now Select your x-axis data from the drop down list of   and y-axis data from the drop down list of Y .
  • Click Save Changes


SQL Query Result


  • Charts will be appeared on the screen as shown below.


Chart Preference2


  • You may adjust the size and the position of the Chart Panel by draging it's corncer.

Chart Preference 3

  • Now Click the Generate   button


Chart Preference 4


  • PHP dashboard open source code for the chart will automatically generate, you may copy past this code to your PHP application.


Get a real-time dashboard open source

The Open source dashboard is D3.js based, driven dynamic dashboard, it fetches data from a various type of data source and shows dashboards in real-time. The PHP source code generated by the open-source dashboard for you, which can also be embedded in any PHP application.

Discover insights into your data with the analytics tool

The Open source analytics dashboard tool comes with a powerful data analytics tool, which helps you to stay in the flow of your data from data gathering and collaborate without writing a complex query.

With the help of our powerful open-source analytics dashboard tool, you can create your monthly sales dashboard without any IT assistance. You can retrieve your raw data and create your monthly, quarterly, or yearly sales open-source dashboard through our powerful open-source data analytic tool in a few clicks.

Auto-generated PHP dashboard open source code

 * DashboardBuilder
 * @author Diginix Technologies www.diginixtech.com
 * Support  - http://www.dashboardbuilder.net
 * @copyright (C) 2018 Dashboardbuilder.net
 * @version 2.1.5
 * @license: license.txt

include("inc/dashboard_dist.php");  // copy this file to inc folder 

// for chart #1
$data = new dashboardbuilder(); 
$data->type =  "line";

$data->source =  "Database"; 
$data->rdbms =  "sqlite"; 
$data->servername =  "";
$data->username =  "";
$data->password =  "";
$data->dbname =  "data\Northwind.db";
$data->xaxisSQL[0]=  "SELECT strftime(^%Y-%m^,o.shippeddate) as xaxis, sum(d.quantity) as yaxis from `order details` d, orders o  where o.orderid = d.orderid group by strftime(^%Y-%m^,o.orderdate) limit 50";
$data->xaxisCol[0]=  "xaxis";
$data->yaxisSQL[0]=  "SELECT strftime(^%Y-%m^,o.shippeddate) as xaxis, sum(d.quantity) as yaxis from `order details` d, orders o  where o.orderid = d.orderid group by strftime(^%Y-%m^,o.orderdate) limit 50";
$data->yaxisCol[0]=  "yaxis";
$data->name = "linechart";
$data->title = "Line Chart";
$data->orientation = "";
$data->xaxistitle = "x-axis title";
$data->yaxistitle = "y-axis title";
$data->showgrid = "";
$data->showline = "";
$data->height = "167";
$data->width = "";
$data->col = "0";
$result[0] = $data->result();


<!DOCTYPE html>
	<script src="assets/js/dashboard.min.js"></script> <!-- copy this file to assets/js folder --> 
	<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css"> <!-- Bootstrap CSS file, change the path accordingly --> 

@media screen and (min-width: 960px) {
.id0 {position:absolute;margin-top:67px;}

.panel-heading {line-height:0.7em;}
#kpi {font-size:34px; font-weight:bold;text-align:center;}
#kpi_legand {font-size:11px; color:#999;text-align:center;}


<div class="container-fluid main-container">
<div class="col-md-12 col-lg-12 col-xs-12">
<div class="row">
<div class="col-md-4 col-lg-4 col-md-offset-4 col-lg-offset-4 col-xs-12 id0">
<div class="panel panel-default">
<div class="panel-heading">Line Chart</div>
    <div class="panel-body">
        <?php echo $result[0];?>



Open Source License

This auto-generated PHP source code generated by our Open Source Dashboard PHP is under MIT license, the most popular software license on GitHub, ahead of any GPL variant and other free and open-source software (FOSS) licenses.

This MIT license puts a very limited restriction on reuse and has, therefore, excellent license compatibility. This license permits reuse within proprietary the source code generated by our dashboard tool open-source, provided that all copies of the source code include a copy of the MIT License terms and the copyright notice. This license is also compatible with many copyleft licenses, such as the GNU General Public License (GPL). The source code generated by our open-source tool can be integrated into GPL software.

The source code for your dashboard using PHP and MySQL is a open source, generated by the Dashboard Builder allows you to customize as per your desire needs and can be used an anywhere you want. You can find the complete information about the license here



Now we have a Dashboard open source PHP code which can be used with any web application and can be customized to fit the requirements of the web design. The project also offers free and paid plans. You can also download Free Dashboard Software Open Source version. The code for free open source dashboard can be found on GitHub under this license

Best of all, with our open source business intelligence dashboard tool offers Standard and Enterprise licenses include 100% source code, for you to enhance the functionality or incorporate the Open Source Dashboard into your web application or any PHP software solutions/products, analytics/data science/data warehouse enterprise systems or Joomla, Wordpress or Drupal sites.

All editions of our dashboard tools open source series are still fully functional, for sale and supported and provides increasing levels of support to address the queries of users and developers.

Dashboard software open source can also be implemented using an online API where you don’t have to mix with a PHP script or PHP source code. The online open source dashboard tool uses universal HTML code which can be used in any platform. The data will be added or retrieved from the database using the API. You may find more information about the Online Dashboard.

You may want to take a look at our complete documentation and video tours of the latest version along with a live tour of user interface and step by step instructions for performing key features.

Download Open Source Dashboard