ArtemisQL

A GraphQL migration tool and relational database visualizer

🔎 Overview

ArtemisQL is an open-source web application providing a SQL (Postgres) database GUI and custom-generated GraphQL schema (type defs, queries, mutations) and resolvers created by developers for developers, to ease the transition from REST to GraphQL.

Read more on Medium.
Accelerated by OS Labs.

⚙️ Getting Started

Visit ArtemisQL.io to utilize the tool.

Connect to a database

• Input your PostgreSQL URI
• OR use the sample database to view data rendered in an interactive diagram.

Visualize your data

• Easily view the relationships between the tables via the links that highlight the foreign key constraints.
• Move any table and arrange them to optimally view the structure of the database and the relationships between the tables.

Generate GraphQL Schema

• View the generated GraphQL schema, including the types and associated resolvers.
• Use the copy button to effortlessly integrate the code into your project.

GraphQL Sandbox

• Interactively construct full queries using the sample database.
• Use the "Docs" to explore the possible queries, fields, types, mutations, and more.

🏗️ For Developers - How to Contribute

We would love for you to test our application and submit any issues you encouter. Please feel free to fork your own repository to and submit your own pull requests.

How you can contribute:

• Submitting or resolving GitHub issues
• Implementing features
• Helping market our application

Please make sure you have the following:

• NodeJS
• NPM

1. Clone the repo.

   git clone https://github.com/oslabs-beta/ArtemisQL.git

2. Install the package dependencies.

   npm install

3. Create an .env file in the project root directory and initialize PG_URI constant. If you want to use your own PostgresQL database, feel free to put your URI here. If you would like to use our sample Starwars database, please contact us at helloartemisql@gmail.com.

   PG_URI= 

4. To run the application in development mode, please run following command and navigate to http://localhost:8080/.

   npm run dev

5. To run the application in production mode, please run the following commands and navigate to http://localhost:3000/.

   npm start
   
   npm run build

6. To run the application against our testing suite, please run the following command.

   npm run test

🧬 Built With

• React
• React Flow
• React Router
• Material UI
• GraphQL
• TypeScript
• Node
• Express
• PostgreSQL

🤖 Developers

License

This product is licensed under the MIT License.