Implement custom WordPress tables and queries using $wpdb, WP_Query, and dbDelta.
npx skills add https://github.com/iwritec0de/wp-dev --skill wordpress-database
Please help me install this Agent Skill. Skill: wordpress-database Source: https://github.com/iwritec0de/wp-dev/tree/main/skills/wordpress-database Command: npx skills add https://github.com/iwritec0de/wp-dev --skill wordpress-database
WordPress developers need dependable patterns for creating and maintaining custom database tables, performing migrations, and executing efficient queries. This skill consolidates best practices for working with $wpdb, WP_Query, and dbDelta, along with caching and multisite considerations.
Create your first custom table by implementing dbDelta on plugin activation and verify migrations with version checks.
High-intent search queries and answers about installing and using this skill.
Use dbDelta during plugin activation to create custom WordPress database tables by passing formatted SQL schema statements. This approach enforces safe schema creation and versioning patterns to ensure reliable plugin initialization without manual SQL execution.
Write safe SQL queries in WordPress plugins using the $wpdb->prepare method to escape user input and prevent injection vulnerabilities. This pattern ensures secure database interactions when executing custom queries against standard or custom tables.
dbDelta handles database schema migrations in WordPress by comparing existing table structures against new SQL definitions and applying necessary alterations. It automatically manages column additions and index updates while preserving existing data during version upgrades.
Yes, you can use $wpdb and WP_Query for multisite database deployments by properly prefixing table names and applying safe query patterns. These tools manage site-specific data isolation and performance tuning across multisite network installations.
Custom WordPress database queries fail without table prefixing because the system cannot locate un-prefixed tables in multisite or custom installations. Prefixing table names ensures reliable database connections and prevents data overlap across different sites.
OrcaQubitsCreate custom WooCommerce plugins with file structure, hooks, and autoloading.
sigmadigitalzaReview database schemas, migration files, and query performance.
courtneyr-devSecure WordPress development by sanitizing input, validating data, and escaping output.
SilverAssistCreate and migrate WordPress cf7_api_logs database tables with dbDelta schemas.
