wikimedia-database

Execute SQL queries against Wikipedia database replicas via SSH tunnel.

15|6|Updated Feb 17, 2026

Search Tags:#SQL #database #data retrieval #Wikipedia #SSH tunnel

Ready to run

npx skills add https://github.com/fuzheado/Wikipedia-AI-Skills --skill wikimedia-database

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: wikimedia-database
Source: https://github.com/fuzheado/Wikipedia-AI-Skills/tree/main/.claude/skills/wikimedia-database
Command: npx skills add https://github.com/fuzheado/Wikipedia-AI-Skills --skill wikimedia-database

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pymysql, dotenv, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill enables secure and efficient execution of SQL queries against Wikipedia database replicas, eliminating the need for direct database access and providing guardrails to ensure data integrity and security.

Core Features & Use Cases

Secure SQL Execution: Execute SQL queries against Wikipedia database replicas using an SSH tunnel, ensuring encrypted communication and secure data handling.
Connection Management: Automatically establish and manage SSH tunnels for persistent database connections.
Data Handling Guardrails: Implements strict read-only access and namespace filtering to prevent unauthorized data modifications.
Use Case: Automate data analysis, retrieve specific information, or perform administrative tasks related to Wikipedia without compromising data security.

Quick Start

Execute the SQL query to find the 5 oldest pages in the 'Draft' namespace.

Frequently Asked Questions about wikimedia-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I securely execute SQL queries against Wikipedia database replicas?▼

You can execute SQL queries against Wikipedia database replicas securely by using an SSH tunnel. This establishes encrypted communication and enforces strict read-only access for safe data retrieval and analysis.

Do I need environment variables to connect to Wikipedia database replicas?▼

Yes, environment variables are required for authentication and connection management when accessing Wikipedia database replicas. You must configure these variables before establishing the SSH tunnel to ensure secure data handling.

Can I write data to Wikipedia database replicas through an SSH tunnel?▼

No, you cannot write data to Wikipedia database replicas. The system implements strict read-only access and namespace filtering as data handling guardrails to prevent unauthorized data modifications.

What is the best way to automate data analysis from Wikipedia without direct database access?▼

The best way to automate data analysis from Wikipedia without direct database access is executing SQL queries through an SSH tunnel. This provides persistent, encrypted connections and secure data retrieval without exposing the database directly.

How does an SSH tunnel manage persistent database connections for Wikipedia data retrieval?▼

An SSH tunnel automatically establishes and manages persistent database connections for Wikipedia data retrieval. This ensures continuous encrypted communication while executing SQL queries against the replicas.

What limitations exist when querying Wikipedia database replicas?▼

Limitations of querying Wikipedia database replicas include strict read-only access and namespace filtering. These guardrails prevent unauthorized data modifications, meaning you can only retrieve and analyze data, not alter it.