QUERIFY

Database setup

Users, networking, and security for your connection.

  • Create a read-only PostgreSQL user

    Copy-paste SQL to create a dedicated user with SELECT-only access. No advanced SQL knowledge required.

  • Create a read-only MySQL user

    Copy-paste SQL to create a dedicated MySQL user with SELECT-only access. Works with MySQL 5.7+, MySQL 8.0+, PlanetScale, and AWS RDS.

  • IP allowlisting for Querify

    Static egress IPs and how to allowlist them on AWS RDS, Supabase, Railway, and self-hosted PostgreSQL.

  • Connection checklist

    A quick checklist before you save a new database connection.

  • SQL Server setup guide

    Create a read-only SQL Server login, configure Querify access, and install the ODBC driver for SQL Server 2016+ and Azure SQL Database.