The main purpose of a database schema is to define the structure, organization, and constraints of a database. It outlines how data is stored, organized, and related within the database, including details on tables, fields, data types, and relationships between entities. A well-designed schema ensures data integrity, facilitates efficient queries, and serves as a blueprint for database management. It also aids developers and stakeholders in understanding the data landscape, promoting effective collaboration during application development and maintenance.