DB-management framework for Developers, DBA and DevOps Engineers
Switch branches/tags
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
conf fix #141 Jan 7, 2018
src add descriptions for http parameters Jun 6, 2018
.gitattributes add .gitattributes file May 23, 2017
.gitignore fix #130 Dec 17, 2017
.travis.yml #89 Jan 1, 2018
CODE_OF_CONDUCT.md Create CODE_OF_CONDUCT.md (#169) May 29, 2018
LICENSE fix some checkstyle warnings May 25, 2017
README.md add postgres-dba to configurations list Jun 7, 2018
appveyor.yml fix #91 Sep 2, 2017
pom.xml fix #165 May 14, 2018
test.md fix #104 (#157) Mar 30, 2018

README.md

Database as a Code_

Build Status Build status Coverage Status License codebeat badge Codacy Badge Docker Pulls Main distribution Join the chat at https://gitter.im/sqlboot/Lobby EO badge

SQL-driven* DB-management framework for Developers, DBA and DevOps (*actually, not only SQL)

  • Evolutionary
  • Transparent (DB independent - native old SQL/*QL/JDBC/REST)
  • Polyglot

Destinations

  • Create and manage your DB source code (DDL, DML, etc)
  • Get DB metrics
  • Database reverse engineering
  • Share expert knowledge
  • Multiplatform (REST/Java based)

Concepts

TODO

Self-documentation

sql-boot uses the OpenAPI standard to generate up-to-date documentation for APIs based your SQL-queries metadata. You can use a tool like Swagger-UI or Swagger-Editor to render interactive documentation (for demo requests) or generate client API against the live API server.

How to pronounce

It is pronounced "sequelboot" - https://translate.google.com/?source=osdd#en/en/sequelboot

Try online (on Heroku):

  • table/hr - get all table from "hr" schema
  • table/hr.jobs - get table "hr.jobs"
  • table/hr.users/ - get table "hr.users" with child objects (pk, fk, indexes etc)
  • index/hr.users - get all indexes for table "hr.users"
  • index/hr - get all indexes from "hr" schema
  • index/hr.p* - get all indexes from "hr" schema and starting with "p"
  • pk/hr - get all pk from "hr" schema
  • fk/* - get all fk from all db schemas

Try with Docker and embedded (H2) demo db:

docker run -t -p 8007:8007 mgramin/sql-boot

Build from source:

git clone https://github.com/mgramin/sql-boot
cd sql-boot
mvn package

Base configurations:

Build Status https://github.com/sql-boot/sql-boot-conf

Build Status https://github.com/sql-boot/sql-boot-postgresql

Build Status https://github.com/sql-boot/sql-boot-oracle

Build Status https://github.com/sql-boot/sql-boot-cassandra

Build Status https://github.com/sql-boot/sql-boot-postgres_dba

https://github.com/sql-boot/sql-boot-clickhouse