<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Samuel Chan</title>
    <description>The latest articles on DEV Community by Samuel Chan (@samuelchanhin).</description>
    <link>https://dev.to/samuelchanhin</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3785255%2Fa26752df-aeee-437d-8bd3-dd19663b4ef2.png</url>
      <title>DEV Community: Samuel Chan</title>
      <link>https://dev.to/samuelchanhin</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/samuelchanhin"/>
    <language>en</language>
    <item>
      <title>Local Centralized Database Manager</title>
      <dc:creator>Samuel Chan</dc:creator>
      <pubDate>Sun, 22 Feb 2026 17:11:23 +0000</pubDate>
      <link>https://dev.to/samuelchanhin/local-centralized-database-manager-h01</link>
      <guid>https://dev.to/samuelchanhin/local-centralized-database-manager-h01</guid>
      <description>&lt;p&gt;I Built a Local Database Portal to Manage Multiple Databases in One Place&lt;br&gt;
Managing multiple local databases is still more painful than it should be.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://github.com/SamuelChanHin/database-manager" rel="noopener noreferrer"&gt;https://github.com/SamuelChanHin/database-manager&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fdrqt1cyaj0zpxy1wwhok.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fdrqt1cyaj0zpxy1wwhok.png" alt="Image Of the portal in home page" width="800" height="389"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;em&gt;Switching between terminal commands, tools, and scripts for backup, restore, and migration takes time — especially when you’re handling different database engines in one project.&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;So I built a local database portal that runs with Docker Compose and gives a single interface for common database operations.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;How to run it?&lt;/strong&gt;&lt;br&gt;
To run the portal locally, you only need Docker, just execute &lt;code&gt;docker compose up -d&lt;/code&gt;, then open &lt;a href="http://localhost:3000" rel="noopener noreferrer"&gt;http://localhost:3000&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;What problem does it solve?&lt;/strong&gt;&lt;br&gt;
If you work on multiple services or environments, you probably need to:&lt;/p&gt;

&lt;p&gt;check whether a DB connection is healthy&lt;br&gt;
make backups before risky changes&lt;br&gt;
restore quickly when something breaks&lt;br&gt;
migrate data between databases&lt;br&gt;
Most of us do this manually with different commands each time.&lt;br&gt;
This project turns those tasks into one consistent workflow.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Current features&lt;/strong&gt;&lt;br&gt;
💖 Health Check – verify connection status quickly&lt;br&gt;
📥 Backup – create local database backups in seconds&lt;br&gt;
📤 Restore – recover from backup files when needed&lt;br&gt;
🔄 Migration – move data between databases with less friction&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Why I’m sharing this&lt;/strong&gt;&lt;br&gt;
This started as a personal productivity tool, but I think it can be useful for other developers who run databases locally and want a cleaner workflow.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F414rhhea0v4bqyjqu4tp.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F414rhhea0v4bqyjqu4tp.png" alt="Image of the portal in migration page" width="800" height="324"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;I’m actively improving it and would love feedback from the community.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;If this sounds useful to you:&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;⭐ Follow/Star the repo&lt;br&gt;
🧪 Try it in your local setup&lt;br&gt;
🤝 Contribute (ideas, issues, PRs are all welcome)&lt;br&gt;
I’d love to build this with other devs.&lt;/p&gt;

</description>
      <category>database</category>
      <category>security</category>
      <category>tooling</category>
      <category>lightweight</category>
    </item>
  </channel>
</rss>
