Skip to content
see your database in a new way
Branch: master
Clone or download
Latest commit cecd3ca Jun 27, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github Ts deck (#66) Jun 27, 2019
app fix (#59) Jun 27, 2019
configs makes hot module reloading a thing! (#41) Jun 24, 2019
internals update eslint + prettier (#31) Jun 17, 2019
resources fix (#59) Jun 27, 2019
test update eslint + prettier (#31) Jun 17, 2019
.babelrc makes hot module reloading a thing! (#41) Jun 24, 2019
.dockerignore Ts deck (#66) Jun 27, 2019
.editorconfig
.eslintignore update eslint + prettier (#31) Jun 17, 2019
.eslintrc.js Logout functionality (#36) Jun 21, 2019
.gitattributes Ts deck (#66) Jun 27, 2019
.gitignore Ts deck (#66) Jun 27, 2019
.prettierrc update eslint + prettier (#31) Jun 17, 2019
.travis.yml removes windows, linux builds from test file (#26) Jun 17, 2019
LICENSE Ts deck (#66) Jun 27, 2019
README.md dev -> master Jun 27, 2019
appveyor.yml Ts deck (#66) Jun 27, 2019
babel.config.js icon for electron (#57) Jun 27, 2019
package.json icon for electron (#57) Jun 27, 2019
renovate.json Ts deck (#66) Jun 27, 2019
tsconfig.json Ah themes (#30) Jun 17, 2019
yarn.lock icon for electron (#57) Jun 27, 2019

README.md

PRs Welcome License: MIT

SeeQL Title


Welcome to SeeQL (beta): An easy-to-use desktop application that helps you visualize your database tables (including all foreign and primary key relationships), to quickly generate complex queries.

Getting Started

Requirements

You'll need a Postgres database to connect to.

How to Install

Beta Release 0.0.1

MacOS: seeql-0.0.1.dmg

Note: For now, you might need to go to your security settings to allow the app run on your system to allow the application to run.

Or from the terminal, run:

git clone https://github.com/oslabs-beta/seeql.git
cd seeql
yarn
yarn run build
yarn start

Features

Logging In

You have the option to log in with a postgres:// URI connection string, or enter your database credentials individually.

Login

Viewing Database Information

After logging in, you'll see three sections - the side panel, the input box, and the database tables section. In the tables section, when you hover over a primary key in a table, any references to this primary key in other tables will be highlighted. Similarly, if you hover over a foreign key in a table, its related primary key will be highlighted.

Click on any table's info icon to view its information in the side panel.

Choose the Search option above the input box to filter which tables will be displayed. You can pin tables to the top of the page for your convinience by clicking on any table's pin icon.

finalSeeQLViewDB

Generating SQL queries & Viewing the results

You can write a SQL SELECT query in the SQL input box, or automatically generate a query by clicking on the rows of a table. Once your query is complete, click execute query. If your query has any errors, an error message will display telling you exactly where the error occured.

finalGenerateQuery

After clicking execute, you'll be able to see your results in the Results section. Clicking on a column name will sort your table data accordingly. You can filter which rows are visible by clicking the search icon next to each column name.

Resources

Built on Electron, React and Typescript

Creators: Kate Matthrews, Tyler Sayles, Ariel Hyman, Alice Wong

You can’t perform that action at this time.