Get the complete database schema for all tables. This includes table names, column names, data types, nullable status, defaults, and comments. Use this to understand the database structure before writing queries. Paginated to prevent token overflow.

Get all keys (primary, foreign, unique) for all tables. This helps understand table relationships for JOIN operations. Returns primary keys, foreign keys, unique keys, and a relationships map showing how tables connect. Paginated to prevent token overflow.

Execute a raw SELECT query on the database. This tool provides read-only access with automatic pagination. The query is validated to ensure only SELECT statements are allowed. Results are paginated to prevent overwhelming responses.

Get detailed information about a specific table including all columns, their types, keys, and comments.

Get a list of all tables in the database with their metadata (type, comment, engine, row count). Paginated to prevent token overflow.

Search for tables or columns by name pattern. Useful for finding specific tables or columns when you don't know the exact name. Paginated to prevent token overflow.