title: How to access in-memory h2 database from Intellij IDEA
body: <p>In Spring Boot project I am trying to see in-memory tables from my IDE.</p>
  
  <blockquote>
    <p>How to access in-memory h2 database from Intellij IDEA.</p>
  </blockquote>
  
  <p>Here is a snippet from my <strong>application.yml</strong>:</p>
  
  <pre><code> h2:
      datasource:
          url: jdbc:h2:mem:mydb
          username: username
          password: 123
          driver-class-name: org.h2.Driver
          init-sql: h2.sql
      console:
        enabled: true
        path: /search/console
        settings:
          trace: false
          web-allow-others: false
  </code></pre>
  
  <p>Intellij has no field to input username for in-memory database:
  <a href="https://i.stack.imgur.com/pbSBt.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/pbSBt.jpg" alt="Intellij has no field to input username for in-memory database"></a>
  Test Connection shows success, however it doesn't see tables from h2.sql.
  I can access them using h2 console. </p>