3.6 Example Use Cases and Prompts

Here are a few examples of natural language requests you can use to perform various database operations through an MCP client connected to the SQLcl MCP Server.

Table 3-1 Natural Language Prompts for Oracle Database Operations

Operation	Description	Complexity	Example Prompt to Client
Connecting to databases	Establish database connections with automatic authentication and connection management.	Basic	Connect to the HR database
Running simple queries	Run basic SQL queries with readable results.	Basic	Show me recent orders, or Which customers are in California?
Browsing a database schema	Interactively explore table structures, columns, and relationships.	Basic	Which tables contain customer information?, or Show me the structure of the Orders table
Checking connection status	Monitor the database session health and connectivity with real-time status reporting.	Basic	Which database am I currently connected to?
Performing complex analytical queries	Execute sophisticated analytical operations with hierarchical breakdowns and advanced SQL features.	Advanced	Show me a hierarchical breakdown of sales by region and product category with year-over-year growth percentages
Performing multi-environment operations	Coordinate work across development, testing, and production database environments.	Advanced	Compare the customer counts between our development and production databases
Managing transactions	Manage complex transactions with capabilities for review and rollback.	Advanced	Update all customer records in the Northeast region but let me review the changes before committing
Monitoring performance	Analyze query performance and receive optimization suggestions.	Advanced	Show me which queries are running slow today and provide optimization tips