sql-executor

To execute SQL queries and export results, you can run SQL commands against SQLite, PostgreSQL, or MySQL databases and directly save the retrieved data as CSV or JSON files. This simplifies data retrieval and reporting tasks.

Yes, you can run SQL queries against a PostgreSQL database and export the output to JSON. The skill supports PostgreSQL, MySQL, and SQLite, allowing you to format query results into human-readable tables or export them directly.

To connect to MySQL and execute SQL commands, you need the database connection credentials. The skill utilizes Python's built-in sqlite3 module for SQLite, while requiring external libraries to support MySQL and PostgreSQL database interactions.

You can query a SQLite database file by providing the file path and the SQL command. The skill processes the query using Python's sqlite3 module and automatically formats the retrieved data into a human-readable table format for immediate analysis.

Yes, exporting database query results for marketing reports is fully supported. You can extract specific records, such as recent customer registrations from PostgreSQL, and export them directly to a CSV file for immediate downstream use.