描述
Advanced SQL is an Unreal Engine plugin that allows your project to communicate with MariaDB or MySQL databases directly from Blueprints.
The plugin provides asynchronous database queries, prepared statements for security, and a connection pool for performance, making it suitable for systems such as player accounts, character progression, inventories, and persistent world data.
Features
• Blueprint-based SQL queries
• MariaDB and MySQL support
• Asynchronous database operations (no game thread blocking)
• Prepared statements to prevent SQL injection
• Connection pooling for improved performance
• Retrieve full database rows or single values
• Execute INSERT, UPDATE and DELETE commands
• Configurable database connection via .ini
Included Blueprint Nodes
• ExecuteSQLRow
• ExecuteSQLValue
• ExecuteSQLCommand
• ExecuteSQLPreparedCommand
• GetSQLColumnValue
Typical Use Cases
• Player account systems
• Character save/load systems
• Inventory storage
• Persistent world data
• Leaderboards
• Backend-driven gameplay systems
Requirements
• Unreal Engine 5
• MariaDB or MySQL server
• Windows (Win64)
Important Security Note
Clients should never connect directly to the database.
Always execute database queries on the server side using RPCs.
Prepared statements are included to help prevent SQL injection attacks.
Future Improvements
• Typed column retrieval nodes
• Struct mapping for query results
• SQL transaction support
• Query batching
• Blueprint query builder
• Row iteration utilities
• Query performance profiling
• JSON column support
• Automatic database reconnection
Documentation
A full setup guide is included covering:
• MariaDB installation
• Database setup using HeidiSQL
• Creating database users and permissions
• Plugin configuration in Unreal Engine
• Example queries and Blueprint usage