The latest articles on DEV Community by Kasra Khaksar (@kasrakhaksar). https://dev.to/kasrakhaksar https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3991103%2Fa8e34f38-eb86-4d2e-be74-86b0a6904a36.jpg https://dev.to/kasrakhaksar en Kasra Khaksar Thu, 18 Jun 2026 15:08:39 +0000 https://dev.to/kasrakhaksar/introducing-py-auto-migrate-database-migration-made-simple-1oke https://dev.to/kasrakhaksar/introducing-py-auto-migrate-database-migration-made-simple-1oke <p>Honestly, sometimes migrating between databases during a project is difficult.</p> <p>For example, transferring tables between relational databases or transferring data between a relational database and a NoSQL database.</p> <p>That's why I built <strong>Py-Auto-Migrate</strong>.</p> <h2> What is Py-Auto-Migrate? </h2> <p>Py-Auto-Migrate is an open source tool that automatically transfers data between different database systems.</p> <p>Simply provide a <strong>source</strong> and <strong>target</strong> database, and the tool will:</p> <ul> <li>Detect schemas automatically</li> <li>Map data types between databases</li> <li>Create missing tables and databases</li> <li>Migrate data with minimal configuration</li> </ul> <h2> Installation </h2> <div class="highlight js-code-highlight"> <pre class="highlight shell"><code>pip <span class="nb">install </span>py-auto-migrate </code></pre> </div> <p>Example:<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight shell"><code>py-auto-migrate migrate <span class="se">\</span> <span class="nt">--source</span> <span class="s2">"mongodb://user:pass@localhost:27017/source_db"</span> <span class="se">\</span> <span class="nt">--target</span> <span class="s2">"mysql://user:pass@localhost:3306/target_db"</span> </code></pre> </div> <h2> Features </h2> <ul> <li>Supports SQL and NoSQL databases</li> <li>Automatic schema detection and creation</li> <li>Migrate a single table or an entire database</li> <li>AI-powered filtering and querying using natural language (only relational databases)</li> <li>Web dashboard</li> </ul> <h3> Supported Databases </h3> <ul> <li>MySQL</li> <li>PostgreSQL</li> <li>Oracle</li> <li>SQL Server</li> <li>MariaDB</li> <li>SQLite</li> <li>MongoDB</li> <li>Redis</li> <li>DynamoDB</li> <li>Elasticsearch</li> <li>ClickHouse</li> </ul> <h2> Web Dashboard </h2> <p>For users who prefer a GUI, Py-Auto-Migrate includes a dashboard:<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight shell"><code>py-auto-migrate dashboard </code></pre> </div> <p>⚠️ <strong>Py-Auto-Migrate is still in its early stages and should not be considered a fully stable release yet.</strong></p> <h2> Project links : </h2> <p><strong>GitHub:</strong> <a href="https://github.com/kasrakhaksar/py-auto-migrate" rel="noopener noreferrer">https://github.com/kasrakhaksar/py-auto-migrate</a></p> <p><strong>PyPI:</strong> <a href="https://pypi.org/project/py-auto-migrate/" rel="noopener noreferrer">https://pypi.org/project/py-auto-migrate/</a></p> python opensource database ai