Meraki DataMagic - Using SQL Queries

Introduction

As well as viewing your data in the user interface, you may want to use SQL queries. Magic Suite uses PostgreSQL.

Remote access to port 5432

To keep your data secure, contact us to set up access as follows:

  1. Click the Feedback icon (speech bubble)
  2. From the Type drop-down, select Support Request
  3. In the Summary box, enter your company name followed by "Remote SQL Access"
  4. In the Description, enter:
    • The IP address range or ranges of the machines you will access the database from
    • The user names that need access
    • Any table restrictions you want for each user
  5. Click Submit and wait to hear from us. Requests are dealt with in UK business hours

Database schema

The DataMagic database schema is documented in the Database Schemas folder of the Library. It is an interactive document, which you should download onto your own machine. Once downloaded, you can pan, zoom and rearrange tables, and download a copy of the view you want.

Reconnection

Reconnection

Reconnection

timed out

timed out

Attempt of

Reload
An unhandled error has occurred. Reload 🗙