Pricing

Pay per event

Try for free

Go to Apify Store

MySQL Database Extractor

Try for free

Connects to a MySQL database and extracts rows from selected tables, returning each row as a flat JSON object. Supports connection strings, SSL, table filtering, and row limits.

Pricing

Pay per event

Rating

5.0

(1)

Developer

ParseForge

Actor stats

Bookmarked

Total users

Monthly active users

10 days ago

Last modified

Categories

Automation

Developer tools

You can access the MySQL Database Extractor programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = {
9    "host": "51.222.13.168",
10    "port": 3307,
11    "database": "myapp_db",
12    "username": "appuser",
13    "password": "apppass123",
14    "ssl": False,
15    "tables": [],
16    "excludeTables": [],
17    "maxRowsPerTable": 100,
18}
19
20# Run the Actor and wait for it to finish
21run = client.actor("parseforge/mysql-database-extractor").call(run_input=run_input)
22
23# Fetch and print Actor results from the run's dataset (if there are any)
24print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
25for item in client.dataset(run.default_dataset_id).iterate_items():
26    print(item)
27
28# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

MySQL Database Extractor - Export Tables to CSV, JSON, Excel API in Python

The Apify API client for Python is the official library that allows you to use MySQL Database Extractor API in Python, providing convenience functions and automatic retries on errors.

Install the apify-client

$pip install apify-client

Other API clients include:

MySQL Database Extractor API in JavaScript

MySQL Database Extractor API through CLI

MySQL Database Extractor OpenAPI definition

MySQL Database Extractor API

PostgreSQL Database Extractor

parseforge/postgresql-database-extractor

Extracts data from PostgreSQL databases. Connects via connection string or individual credentials, supports SSL, table selection, and row limits. Returns each row as a flat JSON object.

ParseForge

5.0

MongoDB Database Extractor

parseforge/mongodb-database-extractor

Connects to a MongoDB database and extracts documents from selected collections into a flat dataset. Supports connection strings, SSL, authentication, and per-collection document limits.

ParseForge

5.0

MySQL Insert

petr_cermak/MySQL-insert

This act takes a crawler execution and inserts it's results into a remote MySQL database.

Petr Cermak

AI Data Bridge: Multi-Database Connector

the.beast/ai-data-bridge

Stop juggling 7 different database tools. AI DataBridge connects PostgreSQL, MySQL, MongoDB, Airtable, Notion, and Google Sheets through a single MCP interface. Ask questions in plain English—get answers from any database instantly. AI database connector, multi-database integration

mr beast

5.0

Database Schema Explorer

balathon/database-schema-explorer

This Apify Actor connects to various types of databases (SQLite, PostgreSQL, MySQL, Oracle, Microsoft SQL Server), explores their schemas, provides detailed information about tables and columns, shows row counts, and optionally reads sample data.

Balasai Sigireddy

Database MCP Server

constant_quadruped/database-mcp-server

MCP Server for AI database access. Connect to PostgreSQL, MySQL, or SQLite. Query data, inspect schemas, list tables, describe columns, view indexes and foreign keys. 11 tools for complete database intelligence. Works with Claude Desktop and any MCP client.

Table Extractor — Scrape HTML Tables from Any URL to JSON/CSV

eliai/webpage-tables-extractor

Table extractor for webpages: pass a URL and get every HTML data table back as structured rows — JSON via the API or dataset, CSV/Excel via one-click export. Layout tables skipped automatically. For analysts, developers and AI agents. $0.02 per page, failures free.

Broke to Built

CBS Netherlands Statistics Scraper

parseforge/cbs-netherlands-statistics-scraper

Scrapes CBS OpenData tables by table ID and returns each row of the TypedDataSet as a flat object. Supports up to 1,000,000 records per run.

ParseForge

Ofsted Providers Companies House Enrichment

alkausari_mujahid/ofsted-providers-companies-house-enrichment

Syncs UK Ofsted provider names from a configurable source table, matches each one against Companies House using fuzzy search, and stores verified company profiles, registered addresses, and active directors back into your MySQL or Supabase database — automatically skipping duplicates and aliases.