title: Connect to a running app's SQLite database using Android Studio and Database Navigator
body: <p>I have just started working on an Android project for work and I found a bug that requires checking the SQLite database my app is using on runtime, to search for inconsistent data.</p>
  
  <p>I came back to working on Android just now, but I worked on Android projects years prior, and I remember using Device Monitor to check the database's tables and data on my device during runtime, but that feature has been deprecated and removed from Android Studio 3.2 (which I am using right now).</p>
  
  <p>I have searched for solutions on Stack Overflow and beyond for hours now, and all solutions I found range from </p>
  
  <blockquote>
    <p>copy the .db file from your device to your computer and open on a SQLite browser of your choice</p>
  </blockquote>
  
  <p>to </p>
  
  <blockquote>
    <p>download this super-shady-tool-that-has-few-to-no-features-at-all-and-can-barely-browse-the-database and after hours of browsing and editing configuration files and running commands on the console MAYBE you'll connect to the database on runtime</p>
  </blockquote>
  
  <p>The first one I can't do because I need to view and run queries on <strong>the same database my app is currently using while debugging</strong> and the second one is not safe to try.</p>
  
  <p>So I discovered the plugin <strong>Database Navigator</strong> for Jetbrains-related IDEs (<a href="https://plugins.jetbrains.com/plugin/1800-database-navigator" rel="nofollow noreferrer">https://plugins.jetbrains.com/plugin/1800-database-navigator</a>) that promisses to give a nice UI for connecting and viewing data and running querys all from inside Android Studio, but I don't know how to configure a connection to a device during a debug process.</p>
  
  <p>I found the <strong>Android Debug Database</strong> (<a href="https://github.com/amitshekhariitbhu/Android-Debug-Database" rel="nofollow noreferrer">https://github.com/amitshekhariitbhu/Android-Debug-Database</a>) that <strong>actually works and is easy to configure</strong>, but I found it quite limited and runs on the browser (I would like something from inside Android Studio), although I set it aside as an "if anything else fails" solution.</p>
  
  <p>My priority is to setup <strong>Database Navigator</strong> on Android Studio itself for easy work.</p>