Avoid loading millions of rows at once by opening a server-side cursor for a SELECT query. It returns a cursor ID to fetch rows incrementally, with automatic cleanup after 5 minutes.
MIT
519,350 tools. Updated 2026-09-06 07:28
"How to fetch and query data using a MySQL cursor" matching MCP tools:
- Execute SQL queries in Adb MySQL Cluster to retrieve data, update records, or perform database operations through the MCP server interface.Apache 2.0
- Fetch a paginated list of rooms and desks from Logitech Sync using a continuation cursor. Customize with projection fields and detail level.MIT
- Fetch organizations efficiently using cursor pagination and date filters for scalable data synchronization and large-scale exports.MIT
- Fetch the authenticated user's Threads posts. Paginate with limit and cursor to retrieve additional pages.MIT
- Search curated SPARQL example queries from UniProt by free-text over descriptions and keyword tags. Find relevant query examples to learn how to query UniProt data.MIT
Matching MCP Servers
- AlicenseAqualityCmaintenanceRead-only MySQL MCP server that lets AI agents list tables, describe schemas, and run SELECT/SHOW/EXPLAIN queries with a row cap, bound to a single database for safety.3MIT
- AlicenseAqualityAmaintenanceA Model Context Protocol server that provides read-only MySQL database queries for AI assistants, allowing them to execute queries, explore database structures, and investigate data directly from AI-powered tools.36113MIT
Matching MCP Connectors
- arjunkmrm-fetchOAuth
Fetch web pages and extract exactly the content you need. Select elements with CSS and retrieve co…
- smithery-ai-fetchOAuth
A simple tool that performs a fetch request to a webpage.
- Read agent stdout/stderr from a character cursor. Pass the returned cursor to fetch only new output for a task.Apache 2.0
- Identify and analyze slow MySQL queries using performance_schema data to optimize database performance by examining execution times, row statistics, and query patterns.Apache 2.0
- Execute read-only SQL SELECT queries to retrieve data from a MySQL database. This tool enables data analysis and information extraction through direct database queries.MIT
- Retrieve the execution plan for a SQL query without executing it. Supports PostgreSQL, MySQL, and Redshift, returning JSON or text plans for query optimization.MIT
- Creates compressed remote MySQL, PostgreSQL, or MongoDB backups over SSH without modifying the source database. Supports transaction-safe MySQL dumps and PostgreSQL custom-format backups.MIT
- Fetch prediction markets from supported exchanges using cursor-based pagination. First request caches all markets; subsequent calls use the cached snapshot until expiration.MIT
- Analyze MySQL query execution plans to identify performance bottlenecks, index usage, and optimization opportunities using EXPLAIN functionality.Apache 2.0
- Register a new MySQL or Snowflake database connection to enable data reconciliation tasks. After adding, verify the connection using test_datasource.MIT
- Fetch all persons efficiently using cursor-based pagination and date filters, ideal for large-scale data synchronization and ETL pipelines.MIT
- Fetch tickets with cursor pagination. Pass the returned after_cursor as `cursor` to navigate pages.Apache 2.0
- Terminate a running MySQL query or connection thread by process ID to stop problematic operations. Requires readOnly mode disabled.MIT
- Retrieve data and inspect schema safely with read-only MySQL queries, validated to allow only SELECT, SHOW, DESCRIBE, and EXPLAIN statements.MIT
- Search tweets inside a specific Twitter community using a query string. Supports pagination to browse all matching results.MIT
- Analyze MySQL query patterns to identify full table scans and inefficient index usage, then generate prioritized index recommendations for performance optimization.Apache 2.0
- Fetch tweets from a specified Twitter list, with pagination support using a cursor to retrieve additional batches.MIT