Skip to content

oslabs-beta/seeql

Repository files navigation

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