F5-TTS Model Installation on Windows - Easy Step by Step Tutorial

Starting a new project with an empty database schema? Stop writing DDL scripts manually. With **SQLcl MCP Server** and any good AI agent (Cline, Cursor, Claude, etc.), you can generate realistic tables, relationships, sample data, and useful views — all from a single well-crafted prompt.

This powerful combination turns natural language into production-ready database objects in under 5 minutes.

Why This Approach Rocks

• Zero manual DDL writing
• Consistent, realistic sample data with proper constraints
• Foreign keys, indexes, comments — all handled automatically
• Ready-to-use views for dashboards
• Works with any Oracle database (19c, 23ai, 26ai, etc.)

Prerequisites

• SQLcl with MCP Server enabled
• VS Code + SQL Developer for VS Code extension
• An AI coding agent (Cline recommended)
• A test database user with CONNECT, RESOURCE, and DB_DEVELOPER_ROLE

The Ultimate Starter Prompt

Copy and paste this prompt into your AI agent (replace <USERNAME> with your schema name):

# Create realistic vehicle schema with sample data and views

## Task
1. Connect as user <USERNAME>. If unsure, list available connections and ask me to choose.

2. Create these tables with proper constraints:
   - car, truck, motorcycle (with make, model, year, engine_displacement, wheelbase, etc.)
   - manufacturer (dba_name, hq_city, hq_country, founded_year, ownership_type)

   Add: Primary keys, Foreign keys, Indexes, Comments, and any useful extra columns.

3. Insert realistic sample data:
   - 50 rows each for car/truck/motorcycle
   - 25 rows for manufacturer
   Use bulk INSERT statements and COMMIT after each.

4. Show first 5 rows of every table to verify.

5. Create these 4 views + recommend 2 more useful ones with comments:
   - Vehicle Count by Manufacturer
   - Average Engine Displacement by Vehicle Type
   - Vehicles by Year of Manufacture
   - Manufacturer Details with Vehicle Counts

6. Once done, disconnect from the database.

How to Execute

1. Start SQLcl MCP Server
2. In your AI agent (e.g. Cline), create a new task and attach the prompt
3. Switch to **Plan** mode first → Review the plan
4. Switch to **Act** mode and let the agent execute
5. Approve steps as they appear

What You’ll Get Automatically

• 4 fully normalized tables with proper relationships
• Realistic sample data (no duplicates, valid FKs)
• Indexes and comments for maintainability
• 4+ useful analytical views ready for dashboards
• Clean, commented SQL you can version-control

Best Practices & Tips

• Always review the plan before switching to Act mode
• Use a dedicated test schema
• Be extremely specific in your prompt — the more details, the better the result
• Save successful prompts in a library for reuse
• Combine with SQLcl Projects (Liquibase + Git) for version control

Conclusion

SQLcl MCP Server + a smart AI agent is one of the fastest ways to bootstrap Oracle schemas in 2025–2026. What used to take hours of tedious scripting now takes minutes of thoughtful prompting.

Try it today — you’ll never want to create sample schemas manually again.