Data & Analytics Agent Skills
Data agent skills make AI agents useful for data work: writing SQL, cleaning datasets, building pipelines, working with spreadsheets, and producing analyses. Each skill is a reviewed SKILL.md file that teaches the agent one workflow well, ready to install in seconds.
Data & Analytics
1,725 skills
mariadb-corporation mariadb-dump
Explains MariaDB-specific defaults and traps of the mariadb-dump client for dev workflows, including consistent backups, routines/events flags, diffable dumps, idempotent seeding, and restore via the mariadb client.
0
mariadb-corporation mariadb-show
Explains MariaDB-specific SHOW statement syntax, including replication terminology, filtering rules, and diagnostic commands like SHOW EXPLAIN and SHOW ANALYZE.
0
mariadb-corporation mariadb-grant
Documents MariaDB-specific GRANT behavior, including privilege scope levels, implicit account creation, MariaDB-only privileges, roles, proxy grants, resource limits, and TLS options, to help write accurate GRANT statements.
0
mariadb-corporation mariadb-delete
Covers MariaDB-specific DELETE syntax and behavior, including RETURNING, multi-table forms, temporal-table deletion, and DELETE vs TRUNCATE differences.
0
mariadb-corporation mariadb-import
Bulk-load text files into MariaDB tables using the mariadb-import client, covering table-name-from-filename rules, TAB defaults, --local vs server-side reads, duplicate handling, and parallel loads.
0
mariadb-corporation mariadb-insert
Documents MariaDB-specific INSERT syntax and behavior, including RETURNING, ON DUPLICATE KEY UPDATE, INSERT IGNORE, and various forms and modifiers, to help write and review INSERT statements.
0
mariadb-corporation mariadb-update
Documents MariaDB-specific UPDATE syntax and behavior, including single-table vs multi-table forms, assignment evaluation order, RETURNING with OLD_VALUE(), temporal tables, and common pitfalls. Use when writing, generating, or reviewing UPDATE statements targeting MariaDB.
0
mariadb-corporation mariadb-vector
Provides best practices for using MariaDB's built-in vector support for AI workloads, including SQL syntax for vector columns, indexes, distance functions, and RAG patterns.
0
mariadb-corporation mariadb-explain
Explains MariaDB-specific EXPLAIN and ANALYZE syntax, including FORMAT=JSON, SHOW EXPLAIN/ANALYZE FOR, and the standalone ANALYZE statement that executes queries.
0
mariadb-corporation mariadb-features
Explains MariaDB-specific features and behaviors that differ from MySQL, including system-versioned tables, RETURNING, sequences, and version-specific defaults, to help optimize and migrate MariaDB applications.
0
mariadb-corporation mysql-to-mariadb
Guides developers migrating applications from MySQL to MariaDB, covering authentication, JSON handling, replication, and SQL syntax differences.
0
mariadb-corporation mariadb-drop-user
Explains MariaDB-specific behavior of DROP USER and RENAME USER, including multiple accounts per statement, IF EXISTS handling, active-connection warnings, and effects on privileges and definers. Use when writing or reviewing account-lifecycle SQL for MariaDB.
0
mariadb-corporation mariadb-alter-table
Documents MariaDB-specific ALTER TABLE syntax and behavior, including online DDL algorithms, lock modes, lock timeouts, idempotent subclauses, system versioning, and partition operations, for writing and reviewing schema migrations.
0
mariadb-corporation mariadb-create-user
Documents MariaDB-specific CREATE USER syntax and behavior, including authentication chaining, TLS options, resource limits, password expiry, and account locking, to help write accurate statements.
0
mariadb-corporation mariadb-create-index
Explains MariaDB-specific CREATE INDEX and DROP INDEX syntax, including mapping to ALTER TABLE, prefix lengths for TEXT/BLOB, lack of expression indexes, real descending indexes, IGNORED indexes, and index kinds. Use when writing or reviewing index statements for MariaDB.
0
mariadb-corporation mariadb-json-functions
Catalog of MariaDB JSON functions with signatures and semantics, covering constructors, extraction, modification, merging, validation, introspection, and formatting. Use when writing SQL that builds, queries, or alters JSON data in MariaDB.
0
mariadb-corporation mariadb-truncate-table
Explains MariaDB-specific TRUNCATE TABLE semantics: DROP privilege, implicit commit, AUTO_INCREMENT reset, trigger and FK behavior, and restrictions on system-versioned tables and sequences.
0
mariadb-corporation mariadb-create-database
Provides MariaDB-specific syntax and behavior for CREATE, ALTER, and DROP DATABASE statements, including OR REPLACE vs IF NOT EXISTS, charset and collation defaults, and the absence of RENAME DATABASE.
0
mariadb-corporation mariadb-set-transaction
Explains MariaDB-specific SET TRANSACTION behavior, including scope rules, isolation levels, and innodb_snapshot_isolation conflict detection, to help write correct transaction statements and retry logic.
0
mariadb-corporation mariadb-create-procedure
Documents MariaDB-specific CREATE PROCEDURE syntax, including OR REPLACE/IF NOT EXISTS exclusivity, DEFINER and SQL SECURITY behavior, parameter modes, DEFAULT values, advisory characteristics, privilege requirements, and the client-side DELIMITER convention.
0
mariadb-corporation mariadb-string-functions
Reference for MariaDB string functions: extraction, length, search, concatenation, modification, case, PCRE2 regex, formatting, and encoding, with common pitfalls and version notes.
0
mariadb-corporation mariadb-numeric-functions
Reference for MariaDB numeric and math functions, covering rounding, division, powers, logs, trigonometry, randomness, base conversion, checksums, and formatting, with guidance on exact-vs-approximate types and division-by-zero behavior.
0
mariadb-corporation mariadb-schema-management
Manages a MariaDB database schema across its lifecycle using the MariaDB Schema Management plugin via the mariadb-shell MCP server, covering project creation, versioned development, releases, and deployment.
0
mariadb-corporation mariadb-query-optimization
Provides best practices for optimizing MariaDB queries, including indexing strategies, EXPLAIN analysis, pagination, histogram statistics, and MariaDB-specific optimizer settings.
0
mariadb-corporation mariadb-aggregate-functions
Reference for MariaDB aggregate functions, covering counting, totals, extrema, string and bitwise aggregation, and statistical functions, with guidance on NULL handling and common pitfalls.
0
mariadb-corporation mariadb-date-time-functions
Reference for MariaDB's built-in date and time functions, covering current time, arithmetic, differences, extraction, parsing, formatting, Unix time, time-zone conversion, construction, and Oracle-compatible helpers, with guidance on version-specific behavior and common pitfalls.
0
mariadb-corporation mariadb-rest-service-create
Creates a MariaDB REST Service by configuring the REST metadata schema, creating the service and REST schema, and exposing tables, views, and routines as REST endpoints via SQL DDL in mariadb-shell.
0
mariadb-corporation mariadb-schema-create-script
Guides writing MariaDB-specific database create scripts with best practices for schema objects, session settings, and UUID usage.
0
mariadb-corporation mariadb-connector-odbc-install
Installs and configures MariaDB Connector/ODBC, covering driver manager registration, DSN setup, connection-string keywords, and TLS options for Linux, macOS, and Windows.
0
mariadb-corporation mariadb-connector-python-usage
Explains MariaDB Connector/Python's DB API 2.0 behavior, including qmark placeholders, autocommit, prepared statements, buffered cursors, connection pooling, and error handling, for writing and reviewing Python code that uses the mariadb module.
0
mariadb-corporation mariadb-system-versioned-tables
Best practices for MariaDB system-versioned (temporal) tables, covering creation, querying historical data, managing history growth, and handling ALTER TABLE operations.
0
mariadb-corporation mariadb-schema-management-develop
Develop the next version of a MariaDB Schema Management (MSM) schema by editing the development script and splitting large sections into SOURCE-included files.
0
auto-skiller data-scraper-agent
Builds a scheduled, AI-powered data collection agent that scrapes public sources, enriches results with Gemini Flash, and stores them in Notion, Sheets, or Supabase.
1 · bundle
mhassan0000 xlsx
Creates, edits, and analyzes spreadsheet files (xlsx, xlsm, csv, tsv) with formulas, formatting, and data cleaning, including recalculation and error checking.
1 · bundle
mhassan0000 x-api
Integrates with the X (Twitter) API to post tweets and threads, read timelines, search content, and track analytics using OAuth authentication and rate-limit handling.
1
galyarderlabs financial-analyst
Performs financial ratio analysis, DCF valuation, budget variance analysis, and rolling forecast construction for strategic decision-making.
20 · bundle
Frequently asked questions
What are Data & Analytics agent skills?
Data agent skills make AI agents useful for data work: writing SQL, cleaning datasets, building pipelines, working with spreadsheets, and producing analyses. Each skill is a reviewed SKILL.md file that teaches the agent one workflow well, ready to install in seconds.
Which Data & Analytics skills are most installed?
Popular Data & Analytics skills on SkillMD right now include financial-analyst, mariadb-dump, mariadb-show. Rankings shift as installs change; sort this page by "Most downloaded" for the live list.
Do Data & Analytics skills work with Claude Code and Cursor?
Yes. Every skill here ships as a SKILL.md file, an open format that works in Claude Code, Claude.ai, Cursor, Codex, Windsurf, and 60+ other agents. Install one with npx skillmds add <owner>/<name>, or copy the file into your agent's skills directory.