Export a Planetscale database.
Hello everyone, this question is related to Planetscale.
I have a Planetscale db with 2 tables. Students and certificates. Each student has one certificate.
Is there any way to export the data in order to read it with Excel?
4 Replies
not sure if that's what you want but you could connect from excel directly to your mysql db:
https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-a-mysql-data-source-sql-server-import-and-export-wizard?view=sql-server-ver16
Connect to a MySQL Data Source (SQL Server Import and Export Wizard...
Connect to a MySQL Data Source (SQL Server Import and Export Wizard)
I assume you want to look at the data in your planetscale db but don't know a way: There are database tools that help you with that. Here's a collection:
- Dbeaver: Cross platform, free (https://dbeaver.io/)
- HeidiSQL: Windows only, free (https://www.heidisql.com/)
- TablePlus: Mac & Windows, paid license (https://tableplus.com/)
- DataGrip: Cross platform, paid (https://www.jetbrains.com/datagrip/)
- Navicat: Cross platform, paid (https://www.navicat.com/en/products/navicat-for-mysql)
For the start I would advise you too use HeidiSQL. It's a good crossover between easy to use and not too easy so you are actually learning about your database while using the tool
HeidiSQL - MariaDB, MySQL, MSSQL, PostgreSQL and SQLite made easy
HeidiSQL is a free and powerful client for MariaDB, MySQL, Microsoft SQL Server, PostgreSQL and SQLite
TablePlus | Modern, Native Tool for Database Management.
Modern, native client with intuitive GUI tools to create, access, query & edit multiple relational databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, Cassandra, and Redis.
JetBrains
DataGrip: The Cross-Platform IDE for Databases & SQL by JetBrains
A powerful IDE from JetBrains for SQL on macOS, Windows, and Linux.
Navicat for MySQL | MySQL Database Administration and Development Tool
Navicat for MySQL connects user to any MySQL Server, providing database utilities: Data Modeling Tool, Data Synchronization, Import/Export, Report and more
Looking at the data in planetscale can be done using the <npx prisma studio>.
I wanted to be able to export the data to a format that is readable by Excel.
I managed to do so by backing up my data and then dumping it on my local machine using the pscale CLI.
And then load the .sql files from Excel, and then a vlookup to sort the two tables based on 'studentId'.
Thanks a lot!
haha awesome