<h1>Running on PlanetScale</h1>
<p><a href="https://planetscale.com/">PlanetScale</a> is a MySQL-compatible serverless database platform. PlanetScale uses <a href="https://vitess.io/">Vitess</a> which doesn't support foreign keys and therefore we have to modify <code>schema.mysql.sql</code> as explained below.</p>
<h2>Setup</h2>
<ol>
<li>Fork the <a href="https://github.com/umami-software/umami">https://github.com/umami-software/umami</a> project to your GitHub account.</li>
<li>Create a database on PlanetScale called <code>umami-db</code> and get its connection string (Hint: select "Prisma" from the "Connect with" menu). It should look something like this: <code>mysql://username:password@host/umami-db?sslaccept=strict</code></li>
<li>Add <code>DATABASE_URL</code> and <code>SKIP_DB_CHECK</code> to your <code>.env</code> file:</li>
</ol>
<pre><code>DATABASE_URL=mysql://username:password@host/umami-db?sslaccept=strict
SKIP_DB_CHECK=1
</code></pre>
<ol start="5">
<li>Download the <a href="https://github.com/planetscale/cli/releases">PlanetScale CLI</a> and authenticate with <code>pscale auth login</code>.</li>
<li>Create the tables by running the following command on the root of the project: <code>pscale shell umami-db main &#x3C; sql/schema.mysql.sql</code>.</li>
<li>You should now be able to build and start Umami (<code>yarn build</code> followed by <code>yarn start</code>).</li>
<li>Follow the <strong>Getting started</strong> guide starting from the <a href="/docs/login">Login</a> step and be sure to change the default password.</li>
</ol>
<h3>Troubleshooting</h3>
<p>If are getting an error like the following example:</p>
<pre><code>PrismaClientInitializationError: Can't reach database server at `host.aws-region.psdb.cloud`:`3306`
</code></pre>
<p>You can try add a connection timeout query parameter on your <code>DATABASE_URL</code>:</p>
<pre><code>DATABASE_URL=mysql://username:password@host/umami-db?sslaccept=strict&#x26;connect_timeout=300
</code></pre>


Documentation

Basics

Advanced

Guides