The open-source collaborative IDE for your databases.

Overview

Slashbase

The open-source collaborative IDE for your databases in your browser.

License Commits per month Go verison Release version


Slashbase

About

Slashbase is an open-source collaborative IDE for your databases in your browser. Connect to your database, browse data, run a bunch of SQL commands or share SQL queries with your team, right from your browser!

It's written in Golang and Nextjs React Framework (SPA) and runs as a single Linux binary with PostgreSQL. Documentation is currently WIP.

Demo

Checkout demo at: https://demo.slashbase.com

Installation

The install script is tested on DigitalOcean Ubuntu 20.04 droplet. Requires postgres to run. Install it on your cloud instance or use a managed postgres database. To install Postgres on instance follow this tutorial.

Then run the following commands:

  1. mkdir slashbase && cd slashbase
  2. wget https://raw.githubusercontent.com/slashbase/slashbase-server/main/deploy/install.sh && chmod +x install.sh
  3. ./install.sh
  4. Enter required configs & follow the instructions till the setup completes.
  5. Visit your url on browser and enter the root user credentials you entered while installation to login.

License

See the LICENSE file for license rights and limitations.

Issues
  • Clicking on project, db and datamodel cards works even outside the card.

    Clicking on project, db and datamodel cards works even outside the card.

    Clicking on project, db and datamodel cards work even outside the card. Should only work when clicked inside cards.

    Steps to reproduce:

    • Login to slashbase
    • Click on right side outside of the project card.
    • Click on right side outside of the db card.
    • Click on right side outside of the datamodel card.
    bug good first issue frontend 
    opened by paraswaykole 0
  • New Login Type: Use role accounts

    New Login Type: Use role accounts

    This is a PR for "New Login Type: Use role accounts", adds the following changes:

    • Existing login flow moved to USE_ROOT
    • Adds a new login type ROLE_ACCOUNTS, which creates and uses roles in the db connected to manage permissions for that database.
    • Updates the file structure for routes <> controllers.
    • Updates SQL Query Type logic.
    • Contains breaking changes.
    opened by paraswaykole 0
  • Sort the data models in left side in alphabetical order

    Sort the data models in left side in alphabetical order

    Sort the data models returned by /api/v1/query/datamodel/all/:dbConnId API backend in alphabetical order.

    Where to fix: GetDataModels function in queryengine.go

    good first issue backend enhancement 
    opened by paraswaykole 0
  • Formatting sql query in code editor

    Formatting sql query in code editor

    Basic requirements:

    • Formats/Prettifies SQL query in code editor using some external library.
    • All keywords in query are changed to UPPERCASE
    • All Identifiers in query are unchanged.

    For example:

    The query

    Select * from user where id = 1;
    

    is changed to

    SELECT 
      *
    FROM 
      user
    WHERE
      id = 1;
    
    feature request frontend 
    opened by paraswaykole 0
Releases(v1.0.2-beta)
  • v1.0.2-beta(Feb 20, 2022)

    This is new beta release of Slashbase🚀

    Follow the instructions in readme to install using script in deploy folder.

    What's New:

    • New Feature: Role-permission wise query check security in postgres or use root login.
    • New Feature: Formatting SQL queries.
    • Option to delete db connections added.
    • Improvements, Minor fixes & design fixes.
    • Security fixes.
    • Docker setup added & installation available via docker script.
    • Added telemetry to collect anonymous usage data.

    What's Changed

    • Fixed Datamodel ordering by @RjPatil27 in https://github.com/slashbase/slashbase/pull/3
    • Sql formatting by @nitishrddy in https://github.com/slashbase/slashbase/pull/5
    • click outside project, db connection, data model cards fixed by @priyankabbb in https://github.com/slashbase/slashbase/pull/8

    New Contributors

    • @RjPatil27 made their first contribution in https://github.com/slashbase/slashbase/pull/3
    • @nitishrddy made their first contribution in https://github.com/slashbase/slashbase/pull/5
    • @priyankabbb made their first contribution in https://github.com/slashbase/slashbase/pull/8

    Full Changelog: https://github.com/slashbase/slashbase/commits/v1.0.2-beta

    Source code(tar.gz)
    Source code(zip)
Owner
Slashbase
The open-source collaborative IDE for your databases. Connect to your database, browse data, run a bunch of SQL commands, right from your browser!
Slashbase
🏋️ dbbench is a simple database benchmarking tool which supports several databases and own scripts

dbbench Table of Contents Description Example Installation Supported Databases Usage Custom Scripts Troubeshooting Development Acknowledgements Descri

Simon Jürgensmeyer 68 May 24, 2022
Go package for sharding databases ( Supports every ORM or raw SQL )

Octillery Octillery is a Go package for sharding databases. It can use with every OR Mapping library ( xorm , gorp , gorm , dbr ...) implementing data

BlasTrain Co., Ltd. 165 Jun 13, 2022
Cross-platform client for PostgreSQL databases

pgweb Web-based PostgreSQL database browser written in Go. Overview Pgweb is a web-based database browser for PostgreSQL, written in Go and works on O

Dan Sosedoff 7.3k Jun 23, 2022
Universal command-line interface for SQL databases

usql A universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and many other databases including NoSQ

XO 7.3k Jun 28, 2022
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

OctoSQL OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases, streaming sources and file formats using

Jacob Martin 3.1k Jun 27, 2022
Redis-shake is a tool for synchronizing data between two redis databases. Redis-shake是一个用于在两个redis之间同步数据的工具,满足用户非常灵活的同步、迁移需求。

RedisShake is mainly used to synchronize data from one redis to another. Thanks to the Douyu's WSD team for the support. 中文文档 English tutorial 中文使用文档

Alibaba 2.4k Jun 24, 2022
SQL API is designed to be able to run queries on databases without any configuration by simple HTTP call.

SQL API SQL API is designed to be able to run queries on databases without any configuration by simple HTTP call. The request contains the DB credenti

Çiçeksepeti Tech 24 Jun 21, 2022
Go sqlite3 http vfs: query sqlite databases over http with range headers

sqlite3vfshttp: a Go sqlite VFS for querying databases over http(s) sqlite3vfshttp is a sqlite3 VFS for querying remote databases over http(s). This a

Peter Sanford 42 Jun 22, 2022
Cross-platform client for PostgreSQL databases

pgweb Web-based PostgreSQL database browser written in Go. Overview Pgweb is a web-based database browser for PostgreSQL, written in Go and works on O

Dan Sosedoff 7.3k Jun 30, 2022
test ALL the databases

This project is an integration test, testing various Go database drivers (for the database/sql package). To run these tests, in this directory, run:

Brad Fitzpatrick 107 May 22, 2022
Manage SQL databases, users and grant using kubernetes manifests

SqlOperator Operate sql databases, users and grants. This is a WIP project and should not at all be used in production at this time. Feel free to vali

Stenic 1 Nov 28, 2021
Manage Schema for KubeDB managed Databases

schema-manager Manage Schema for KubeDB managed Databases Installation To install KubeDB, please follow the guide here. Using KubeDB Want to learn how

Kubernetes Database 8 Feb 19, 2022
A go Library for scan database/sql rows to struct、slice、other types. And it support multiple databases connection management

ploto A go Library for scan database/sql rows to struct、slice、other types. And it support multiple databases connection management It's not an ORM. wo

solar 2 Mar 16, 2022
SQLite extension for accessing other SQL databases

dblite SQLite extension for accessing other SQL databases, in SQLite. Similar to how Postgres Foreign Data Wrappers enable access to other databases i

MergeStat 9 May 20, 2022
Client to import measurements to timestream databases.

Timestream DB Client Client to import measurements to timestream databases. Supported Databases/Services AWS Timestream AWS Timestream Run NewTimestre

Tommzn 0 Jan 11, 2022
Use SQL to query databases, logs and more from PlanetScale

Use SQL to instantly query PlanetScale databases, branches and more. Open source CLI. No DB required.

Turbot 1 Feb 13, 2022
This is the code example how to use SQL to query data from any relational databases in Go programming language.

Go with SQL example This is the code example how to use SQL to query data from any relational databases in Go programming language. To start, please m

Muhammad Uzair Mohd Faizul 1 Mar 12, 2022
A simple auditor of SQL databases.

DBAuditor SQL数据库审计系统,目前支持SQL注入攻击审计 环境配置 sudo apt install golang 运行方式 将待审计语句填入test.txt中,然后运行主程序: 直接运行: go run main.go 编译运行: go build main.go ./main 主要目

Yunjie Xiao 4 May 13, 2022
Use SQL to query host, DNS and exploit information using Shodan. Open source CLI. No DB required.

Shodan Plugin for Steampipe Query Shodan with SQL Use SQL to query host, DNS and exploit information using Shodan. For example: select * from shod

Turbot 23 May 10, 2022