<aside> 💡 Cogram lets you query your databases without writing SQL. You can ask your questions in plain English — Cogram will translate them into database queries and retrieve the data you need.

</aside>

Cogram currently supports the following databases: SQLite, PostgreSQL, MySQL, Redshift. We’re working on adding more — please let us know which one we should prioritize and why at [email protected].

TL;DR

In a hurry? Here’s how to get started quickly

  1. Go to dashboard.cogram.com and create an account
  2. Connect your SQLite, MySQL, PostgreSQL, or Redshift database
  3. Start asking questions about your data

Getting started

<aside> 📹 Check out this video on how to get started 👉🏻  link

</aside>

Creating an account

Head over to dashboard.cogram.com, create an account, and sign in.

Connecting your database

After logging in for the first time, you’ll see a message prompting you to connect your database. Choose among the available databases, enter your connection information. Verify the database connection, and click save. Here’s what it looks like for Redshift:

Setting up a Redshift instance in Cogram Dashboard.

Setting up a Redshift instance in Cogram Dashboard.

Editing your schema

Cogram can access one database schema at at time. Once you’ve successfully connected your database, you’ll be given the option to choose the schema you want to use. In the case of SQLite, this always be main , and in the case of PostgreSQL and Redshift, it will most likely be public. In the case of MySQL, it will be whatever schema you set up.