---
title: "What is Map.sql"
description: "What is Map.sql"
url: https://support.travian.com/en/articles/156-what-is-mapsql
collection: "All tips From Beginner to Legend"
updated: 2026-10-27
language: en
alternates: [it, es, cs, tr, pl, ar, fr, de, pt, ru]
---

# What is Map.sql

What is Map.sql

### **map.sql** is a file provided daily by Travian: Legends. It contains detailed information about all villages on a game world map.

The file is updated **every 24 hours at midnight (server time)** and is commonly used by external tools and tool creators. 

Important:

-   The data always reflects the state of the game world **at midnight**, regardless of when you download the file.
    
-   The file may become available **5–20 seconds after midnight**, so avoid requesting it exactly at 00:00:00. 
    

* * *

### What information the file contains

Each map.sql file includes a full snapshot of all villages on a game world.

A typical entry looks like this:

```javascript
INSERT INTO `x_world` VALUES (22028,173,146,5,31912,'Natars 173|146',1,'Natars',0,"",498,NULL,FALSE,NULL,NULL,NULL);
```

Each value represents specific data about a village.

* * *

### How to read the data

Each row contains the following fields:

-   ID
    
-   Coordinates (X, Y)
    
-   Tribe
    
-   Village ID
    
-   Village name
    
-   Player ID
    
-   Player name
    
-   Alliance ID
    
-   Alliance tag
    
-   Population
    
-   Region
    
-   Capital (TRUE/FALSE)
    
-   City (TRUE/FALSE)
    
-   Harbor (TRUE/FALSE)
    
-   Victory Points
    

Notes:

-   If a feature is not supported on a game world, the value will be **NULL**.  
    → For example, regular game worlds may show NULL for region, city, harbor, or Victory Points. 
    
-   TRUE/FALSE values indicate statuses such as whether a village is a **capital**.
    

* * *

### Tribe values in map.sql

Tribes are represented as numbers:

-   1 – Romans
    
-   2 – Teutons
    
-   3 – Gauls
    
-   4 – Nature (not shown in map.sql)
    
-   5 – Natars
    
-   6 – Egyptians
    
-   7 – Huns
    
-   8 – Spartans
    
-   9 – Vikings 
    

* * *

### How to download map.sql

To download the file, add **/map.sql** to your game world URL.

Example:

-   Game world:  
    `https://ts5.x1.europe.travian.com/`
    
-   map.sql file:  
    `https://ts5.x1.europe.travian.com/map.sql`
    

The download starts automatically.

You do **not** need to be registered on that game world to download the file. 

* * *

### How you can use the data

map.sql can be used in several ways. Tools that scan the live game are strictly prohibited and can result in a ban and penalty. Travco is permitted because it uses manually entered data or the map.sql file released each day instead of scanning the live game; its results are always 24 hours out of date.

-   Planning operations (e.g. alliance coordination)
    
-   Monitoring player or game world activity
    
-   General data analysis
    

If you are not familiar with programming:

-   Open the file in a text editor (.txt)
    
-   Copy the content into Excel or a similar tool
    
-   Use **comma-separated columns** to filter and search for specific data 
    

* * *

### Key takeaway

map.sql provides a **daily snapshot of the entire game world**, which you can use to:

-   Analyze villages and players
    
-   Support coordination and planning
    
-   Extract specific data using external tools or spreadsheets
    

Make sure you understand the structure of the data before using it, especially the meaning of each field.