Skip to main content

MySQL

The MySQL connection lets FunnelStory run read-only SQL against your MySQL database to power data models—accounts, users, billing tables, or any view you maintain for analytics.

What FunnelStory uses it for​

  • Data models — SQL queries in the model builder, validated against your instance, with column mapping to FunnelStory properties.

Before you connect​

  • Network — Allow inbound access from FunnelStory’s static egress IPs (Allowed IP addresses), or use an SSH tunnel.
  • Permissions — Use a user with SELECT only on the schemas or views FunnelStory should read.

Add the connection in FunnelStory​

  1. Open Configuration → Connections → Add connection, then choose MySQL.

  2. Complete the fields in the connection form:

MySQL connection form

FieldDescription
Connection nameDisplay name in FunnelStory.
HostServer hostname or IP.
PortMySQL port (often 3306).
DatabaseDatabase name.
UsernameMySQL user.
PasswordMySQL password.
SSH fields (optional)If the form offers tunnel parameters; otherwise configure SSH tunnels separately.
  1. Click Validate, then Add Connection.

After you connect​

Use the connection when configuring models. SQL follows MySQL syntax. See Writing queries for types and timestamps.